Row values to Columns

sandeepsu

Hi Experts,

I am working on one of the report design where in the data is read from the CSV in the below format where X is repeated data


r1 rr1 X X
r2 rr2 X X
r3 rr3 X X

so the requirement here is to transpose the first and second column data , also having format as below

r1 r2 r3 X X
rr1 rr2 rr3

These values r1 - r3 and rr1 to rr3 are all text values so i dont have an option of creating a cube here, so crosstab does not help. I tried using table, data, grid, list but seems like i am not able to do it

Please let me know as to how i can accomplish this task


Thanks in advance,
~ Sandeep

mwilliams

I'm not sure I'm fully understanding. You only want to display X X in the first row of the transposed data? Can you explain further? Maybe with some actual sample data. Thanks.