Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reformatting data
Excel 2003.
A report comes in in RTF format. It has the data for each of the 12 months all in 1 row and 1 column, separated by a space between each one. So there are 12 groups of data in each row, separated by a space between each one. I wanted to reformat that data so that it would have each months data in a separate column/cell. So the 12 groups of data in 1 row and 1 column, would become 12 columns of data on 1 row, the same row, each in its own cell. The data has these formats coming in on Sheet1. Col A ### #,### #.# ##.#% $###,### Thanks for your expert help. -- Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reformatting input data | Excel Discussion (Misc queries) | |||
Reformatting data from one spreadsheet to another in the same work | Excel Discussion (Misc queries) | |||
Reformatting data and consolidating | Excel Worksheet Functions | |||
Data dissapears when reformatting a chart | Charts and Charting in Excel | |||
Data Formatting/Reformatting | Excel Discussion (Misc queries) |