...

View Full Version : Red face copy rows on cell based value and condtionaly paste it to other column



sanketgroup
09-29-2011, 03:13 PM
Hi
this is very dynamic requirement.
I have attached image as well sample sheet for what i need.

In brief:
I want to transfer(cut or moving) the cells to respective column but on same row from where is has been cut.

For example: (where , (comma) means different column

Account No.1
item33,quantity,amount,
item2,quantity,amount,
item48,quantity,amount,

Account No.2
item9,quantity,amount,

Account No.3
item19,quantity,amount,
item2,quantity,amount,
item6,quantity,amount,
item75,quantity,amount,
item52,quantity,amount,

Now i want put it like this

Account No.1 item33,quantity,amount,
Account No.1 item2,quantity,amount,
Account No.1 item48,quantity,amount,

Account No.2 item9,quantity,amount,

Account No.3 item19,quantity,amount,
Account No.3 item2,quantity,amount,
Account No.3 item6,quantity,amount,
Account No.3 item75,quantity,amount,
Account No.3 item52,quantity,amount,

I have also attached image and sample excel file.
[img=http://s4.postimage.org/3208mebvo/data_convert.jpg]
Excel file is attached below.

Spookster
09-29-2011, 11:00 PM
Sounds like you might want to look in to using a pivot table to flatten your data.

sanketgroup
09-30-2011, 10:14 AM
cant use pivot table. as two different fields are in same column.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum