I'd probably do this with a Pivot Table and do some evaluations of the Pivot
Table

Let's assume all of your data is in A1:D8. Select that range and

Data | Pivot Table | Finish
Drag Account to "Drop Row Fields Here"
Drag Description to "Drop Column Fields Here"
Drag Cost to "Drop Data Items Here"
Right click on cell A3 if it reads anything but SUM OF COSTand pull down to
Field Settings
Change to Summarize by SUM (if necessary)
This will show your FSC and Tax for each account and you can back calculate
from the Grand Total to get the Cost.

Someone else may have a better idea, but that's my suggestion to get you
part way there..

Barb Reinhardt
Change to Sum
"ledzepe" wrote:


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