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

"nickr1954" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>