Fill row to coulmn

[online]

Hi experts,

I have data in which column A has customer name and B has product name and C have quantity. I have only four product in product column. I want to convert all product into column and respectively their quantity in each column.

[Chabu]

That is what pivottables do best.

Data/Pivottable and PivotChart report...(in 2003)
Insert/Pivottable (in 2010)

[online]

i want to do it using macro coding. Because customer name are duplicate and pivot table will sum it.
I have attached file.

[Chabu]

That would be the point. But if you don't want that then I suggest adding a column that distinguishes records from the same client.

[Chabu]

But if you really want to do it by hand then look in the attachment.
I added some code to your example that will do what you want.

Select he data range and run the testMypivot macro

Greetings

[online]

Hi Chabu,

Great work.. but there is a little problem i want the result same as i attached the file. you have changed data A1 to B6.

[Chabu]

well change it back...

[CatDaddy]

well change it back...

:rotlaugh: