Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can you please suggest me a way to display rows as columns?
eg: Input
to be displayed like : desired output
PS: values in fieldname
Thanks in advance.
Hi All,
Thanks for the response
I have done it using pivot table.
Thanks,
Simranjeet
You could transform your data with a crosstable-statement: The Crosstable Load.
- Marcus
In a straight table check the horizontal option in presentation
Hi,
We can get using cross table function as well
Hi,
You can use cross table function to achieve your desired output.
Hi,
Please follow this steps to achieve your desired output:
Step-1:Go to Edit Script and select the data source (Excel, CSV ...)
Step-2: Click on next button twice and after that click on CrossTable.
Above, you can select Qualifier fields, Name for Attribute Filed and Data Values. You can see the color combination with these related filed also. Press OK. Now Data is converted to Straight Table.
Now, Click on Finish.
Hi All,
Thanks for the response
I have done it using pivot table.
Thanks,
Simranjeet