Forum Discussion
transposing double column headers
I am facing an issue regarding double column headers. I am using Excel sheets as my data source. I have the following data (sample) with different data types. I need to show the data i...
mvrdj The trick is that you need to first transpose the table (without headers). Then merge the first to columns and transpose the table back. Now promote the first row to headers and an un-pivot. Split the column that contains the merged headers, re-pivot and sort. Example attached.