Challenge #49: Reformatting Transactional Data

[euanwilson]

Spoiler

So to start I used the select records tool to split the data into the 3 lines of header information and the rest of the data set. 

Following the header information, the first tool to be used was the Transpose one. This was done to put the Product/Market/Type into one column rather than them being spread out over different rows. The cross tab tool was used to change the data in column F1 to the Header columns of the data set. This process allowed the data to be displayed in the required format, grouped by Market/Product/Type rather than A/B/C/D. 

For the other part of the original data set, only the transpose tool was required to group the data by Name and Value rather than date. 

The two parts of the data set were then joined and the select tool was used to remove/rename the appropriate columns.

[JonServiceNow]

Transposes can be very tricky at times, even the beginner ones. 

[MohithRai]

Done🚀

Spoiler

[Nvy]

Keeping on learning

[pgneal]

My solution.

Thanks.

[SophieJoanna]

Hello - I have been following this solution through and I may be doing it wrong but the output in your solution doesn't seem to include the date - is that correct? Any help would be appreciated. 

[Nethrah24]

My Solution

[derekbelyea]

Spoiler

[zachcornelison]

Submission attached