Need Help in Tranforming data

[Dilawer]

Hi,

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

Regards

Dilawer

 

[Ed Kelly]

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.

 

[Dilawer]

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.

 

[NormS]

Here's a slightly different approach, not any shorter I'm afraid.

Norm

 

[Ed Kelly]

Norm

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

Nice job.