Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Take a look on this: The-Crosstable-Load
- Marcus
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
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