Need Help in Tranforming data

Dilawer

New member
Joined
Jul 13, 2018
Messages
2
Reaction score
0
Points
0
Excel Version(s)
Office 365
Hi,

In attached file I want to see the columns as per given in sheeet "Required Results"

Regards

Dilawer
 

Attachments

  • Emaildata.xlsx
    76.8 KB · Views: 14
Dilawer

For simplicity I converted your raw data into a table however depending on your data source, size and frequency I might use a data range or indeed an sql interrogation.

I am sure there is a far more elegant way to do this in PQ however you are getting a quick and dirty today.

Knock 'em dead Tiger!

Excuse any Tardiness in responding as I am not on the site much.
 

Attachments

  • Emaildata.xlsx
    104.8 KB · Views: 12
Dilawer

For simplicity I converted your raw data into a table however depending on your data source, size and frequency I might use a data range or indeed an sql interrogation.

I am sure there is a far more elegant way to do this in PQ however you are getting a quick and dirty today.

Knock 'em dead Tiger!

Excuse any Tardiness in responding as I am not on the site much.

Thanks a lot Ed, As you have said, if you could plz share a shorter solution. Thanks in anyway.
 
Here's a slightly different approach, not any shorter I'm afraid.

Norm
 

Attachments

  • Emaildata_NS.xlsx
    105.5 KB · Views: 17
Norm

Never considered stripping down the source data and then merging. Smart!

Nice job.
 
Back
Top