Transpose Row to Column

[gayatri7]

Hi All,

Could you please help with below requirement. I need to display below 'Reference' field value (A,A1, A2, A3) as Column in St. Table (not Pivot table)

Raw Data

Expected o/p

Reason I am not using Pivot table because I have another measures (Such as Response #) and it is coming below these value in Pivot table

something like this, which is not expected.

Could you please help here.

Thanks in Advance!

[vijaynov]

You can create field   in load editor

if(match( Reference , A1,A2,A3,A4,A5) ,Reference ) as reference_New

[sasikanth]

HI, 

would you be able to share some sample data??

[gayatri7]

Hi Vijay,

I have created this fields but how to use as Column label  these value in Table? As shown in below table.