Hi everyone,

I need to reformat a .CSV file that looks like below:

Account Quantity Description Cost
R1234 2 Skids 100.00
R1234 0 FSC 1.50
R1234 0 tax 2.33
R5432 1 box 45.00
R5432 4 bales 50.00
R5432 0 FSC 11.21
R5432 0 tax 10.22

I want the above to look something like below:
ACCOUNT QUANTITY COST FSC tax
R1234 2 100.00 1.50 2.33
R5432 5 95.00 11.21 10.22

I get this .CSV file daily and its usually two thousand plus
rows/lines.

Thanks in advance.


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=513688