Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Formatting/Reformatting
I extract financial data that is formatted Vertically. Looks like; Month1 Month2 Budget Actual Budget Actual Acct1 $123 $150 $125 $170 Acct2 $456 $123 $489 $400 I would like to format it Horizontally. It would look like; Month 1 Month2 Acct1 Budget $123 $125 Actual $150 $170 Acct2 Budget $456 $489 Actual $123 $400 (Assuming the above formatting will be lost attached is a document showing these examples). I have tried to use the transpose function and pivot table and it just isn't working for me. Is there an easy fix that anyone knows of. Thanks for any help or suggestions. Tim +-------------------------------------------------------------------+ |Filename: FormatExample.doc | |Download: http://www.excelforum.com/attachment.php?postid=4143 | +-------------------------------------------------------------------+ -- TimR ------------------------------------------------------------------------ TimR's Profile: http://www.excelforum.com/member.php...o&userid=27843 View this thread: http://www.excelforum.com/showthread...hreadid=495208 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |