| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
(Again) Converting rows to columns
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I transpose rows to columns in a large worksheet? | Excel Discussion (Misc queries) | |||
| REQ: Columns to rows or Rows to Columns | Excel Discussion (Misc queries) | |||
| convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
| Converting Columns to Rows | Excel Worksheet Functions | |||
| How to keep rows together when sorting columns? | Excel Worksheet Functions | |||
Threaded Mode
