data modification

[deepak.kec]

Hi,

I have data in the form mentioned below in the excel,

Column1 Column2

Row 1 Karnataka Bangalore
Row 2 Karnataka Mangalore
Row 3 Karnataka Coorg
Row 4 Tamilnadu Chennai
Row 5 Tamilnadu Vellore

Now i want the data to be modified in the following way mentioned below,
Column1 Column2

Row 1 Karnataka Bangalore,Mangalore,Coorg
Row 2 Tamilnadu Chennai,Vellore

Is it possible to get the expected data using pivot table.

Please let me know in case you know the solution.

[pike]

dude use

Please Login or Register  to view this content.

[deepak.kec]

thanks pike for the help

[pike]

hi deeppak.kec
If the code has solved your question can you please mark the thread [Solve]