| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
(Again) Converting rows to columns
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Rows to Columns | Excel Worksheet Functions | |||
| Converting columns into rows | Excel Discussion (Misc queries) | |||
| Converting columns to rows | Excel Worksheet Functions | |||
| (Again) Converting rows to columns | Excel Discussion (Misc queries) | |||
| Converting Rows to Columns? | Excel Discussion (Misc queries) | |||
Hybrid Mode
