View Full Version : Fill row to coulmn
online
06-01-2011, 10:17 AM
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
06-01-2011, 12:39 PM
That is what pivottables do best.
Data/Pivottable and PivotChart report...(in 2003)
Insert/Pivottable (in 2010)
online
06-03-2011, 03:41 AM
i want to do it using macro coding. Because customer name are duplicate and pivot table will sum it.
I have attached file.
Chabu
06-03-2011, 12:54 PM
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
06-04-2011, 02:51 AM
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
06-04-2011, 09:48 PM
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
06-05-2011, 01:09 AM
well change it back...
CatDaddy
06-06-2011, 10:33 AM
well change it back...
:rotlaugh:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.