Do you know how possible combine columns as described below? (Straight table or Pivot table)
You can use PIVOT table to show such structure.
You can use combination of Straight table and Pivot table.
Create a dummy field for a dimension which incorporates the key differentiator of the "column group", use this field to create the split you require above.
Omit the first 2 rows and then work from there. Work with the columns as opposed to the headers.
Im also curious on how this can be done. Can anyone post a sample? Thanks in advance!
I think that this is what you require:
A as Column1,
B as Column2,
C & D as Column3_Concatenated_Together,
E as Column4
FROM junk.xlsx (ooxml, no labels, header is 2 lines, table is Sheet1);