Subcolumn in table

[#1]

Hi,

Do you know how possible combine columns as described below? (Straight table or Pivot table)

[whiteline]

Hi.

You can use PIVOT table to show such structure.

[its_anandrjs]

You can use combination of Straight table and Pivot table.

[#4]

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.

[Roop]

Omit the first 2 rows and then work from there. Work with the columns as opposed to the headers.

[#6]

Im also curious on how this can be done. Can anyone post a sample? Thanks in advance!

[Roop]

I think that this is what you require:

TableDesc:

LOAD

     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);