Combile multiple rows in one row data

[DipeshVadgama]

Hi All,

I have a raw data which is been spited by its item ID, Customer name, Country, etc.

Example if any cell row have: India, USA, Africa

This country is spited in different rows:

India

USA

Africa

I would like to merge all this multiple entries in to single row. Please find attached file with 2 sheets.

[Anil_Babu_Samineni]

There is no Cell row for all Strings which you want to split in sample?

[sunny_talwar]

Try this

Table:

LOAD [Item ID],

    Concat([Customer Name], ', ') as [Customer Name],

    Concat(Counry, ', ') as Counry,

    Package,

    Concat([Item Number], ', ') as [Item Number],

    [PASS/FAIL]

FROM

[..\..\Downloads\Qlik_Question.xlsx]

(ooxml, embedded labels, table is [Raw Data])

Group By [Item ID], Package, [PASS/FAIL];