Merging data into single cell Pivot

[#1]

Hi Team,

I have data with three dimensions . I want to merge the data of a column into single row. Please find below screenshot for easy understanding of requirement.

Regards,

Sai Krishna.

[sunny_talwar · Accepted solution]

Check here:

Re: Pivot table issue

[#3]

Temp:

Load * Inline [

Sno, ProductFamily, Product, Category, Qty

1, Accessories, Mouse, Hardware, 2

2, Accessories, Keyboard, Hardware, 3

3, Accessories, Headset, Hardware, 1

4, Computer, Windows, Software, 1

5, Computer, Office, Software, 1

];

Final:

Load

     ProductFamily, Category,

     Concat(Product, ',') as Product,

     sum(Qty) as Qty

     Resident Temp

     Group by ProductFamily, Category;

Drop table Temp;

[sorrakis01]

HI,

It's the same question and the same example

Regards,