Is it posable?

[irmantas]

Hi All,

I have this:

Month	Day	City
11	22	Kaunas
11	23	Vilnius
11	24	Kaunas
11	24	Klaipeda
11	25	Kaunas

Need this:

	Mont
Day	11
22	Kaunas
23	Vilnius
24	Kaunas, Klaipeda
25	Kaunas

Is it posable to show few results in one cell? I want show it in PivotTable.

[devarasu07 · Accepted solution]

Yes, just use concatenate with pivot table

Concat(City,',')

or

=aggr(Concat(City,','),Day) // if u r adding dimension as Calculated dimension

[irmantas]

Thank you. It's working.