If you are doing this frequently, you may want to write a macro to do it.
Posting to programming forum for assistance.

"nickr1954" wrote in
message ...

Would appreciate some advice: I am currently downloading some data into
an Excel spreadsheet that gives me the following format:

Dept.# Account# Month Actuals
Dept.# Account# Month Budget

Dept.# Account# Month Actuals
Dept.# Account# Month Budget

Dept.# Account# Month Actuals
Dept.# Account# Month Budget

I would like to get the actuals in one column and the budget in the
next column, but everything else would have to match up (ie make sure i
am matching the same dept and account #). I am not quite sure how to go
about this and am not an Excel expert. Would appreciate any advice you
may have. Thanks


--
nickr1954
------------------------------------------------------------------------
nickr1954's Profile:
http://www.excelforum.com/member.php...o&userid=30907
View this thread: http://www.excelforum.com/showthread...hreadid=505906