I am trying to pivot/rearrange data as shown below

[ahsankhalid]

I have about 300 files to read the sheet1 from it have a list as shown on the left of the picture and  I want to show the data as shown on the right. I want to create columns for all unique value of ColType and put the selection in respective columns. So look at the column heading and area and put the selection there. This is a sample data. real data is about 47K records. 

 

[dwstada · Accepted solution]

Hey @ahsankhalid , use a crosstab tool and configure it like this:

[ahsankhalid]

Genuis!!!!