Merge columns in excel.

[agni_gold]

Please help I want all the yellow color values in single column.

[stigchel]

You can maybe use a crosstable in combination with a purgechar function to not load the numbers, if that is what you want like this

CrossTable(Children, Data,1)

LOAD Parent,

     PurgeChar(Child,'0123456789') as Child,

     PurgeChar(Child1,'0123456789') as Child1,

     PurgeChar(Child2,'0123456789') as Child2

FROM

Test11.xlsx

(ooxml, embedded labels, table is Sheet1);

[santhoo_san]

you can use cross table as said by Piet above in combination with a purgechar function to not load the numbers, if that is what you want like this

CrossTable(Children, Data,1)

LOAD Parent,

    PurgeChar(Child,'0123456789') as Child,

    PurgeChar(Child1,'0123456789') as Child1,

    PurgeChar(Child2,'0123456789') as Child2

FROM

Test11.xlsx

(ooxml, embedded labels, table is Sheet1);

or use it in the object expression as done in the attachment.