Transposing Data - Creating Unique Headings and Formatting Data against Headings

Brytsyt

Hi All,

I am dealing with some data in a standard format as shown below and attached for testing purposes:

I am trying to have the "Template Label" become the headers for the new data set but have these as unique (remove duplicate entries) and have all the corresponding "Comp Items" appear underneath the corresponding Label that it had it attached to.

The result of which is shown in the image below:

I have tried to use the Transpose tool but it didn't appear as I wanted nor did any efforts I made with the cross-tab tool, any help would be greatly appreciated.

Kindest regards,

Test Data for Transposing.xlsx

danilang

Hi @Brytsyt 

The trick here is to sort by template label and use a Multi-row tool grouped by label to generate your row numbers

 

The Dynamic Rename changes the field name underscores that come out of the crosstab back into spaces resulting in 

Dan

Crosstab.yxzp