Can you please suggest me a way to display rows as columns?
to be displayed like : desired output
PS: values in fieldname
Thanks in advance.
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.