Transpose Cols

[raadwiptec]

Hi 

My source data is attached. 2 tabs .sheet 1 showing the Source Data .sheet 2 showing the out put required.

so from Columns AW TO BC in excel shows the column Carieer  Ref 1 to Carieer Ref 7

BD To BJ - Columns RCC-1 to RCC-7

BK- BQ - Alloc Ref -1 to Alloc Ref -7

The above columns needs to be transposed and respective columns needs to be duplicated and categorised under 3 different columns like Carrier Ref, RCC, Alloc 

[marcus_sommer]

Take a look on this: The-Crosstable-Load

- Marcus

[raadwiptec]

Hi Marcus

In the example you provided it transposes basically all the Columns other than Product. But in my case i need to transpose only certain Columns 

[marcus_sommer]

With the order of the fields within the load-statement and the third parameter of the crosstable-statement you could specify which columns should be transposed. If there are multiple but different column-areas which needs to be transposed it might be useful to use several crosstable-statements just with certain data-parts and then to merge them afterwards together again.

- Marcus