| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Raw data output is poor excel format part 1
Hi,
I have data output from a different source which when it is placed in excel, the first column (from up to down) has a site name, then a blank, then certain dates in january (not all dates only those that have data relating to it), then a "sum:" row, then the name of the next site and so on. This makes it awkward to do pivot tables, etc. There are over 1,000 sites. If I insert a column, can I somehow add the site name next to it's relevant 'dates' section using a formula? Any other suggestions would be greatly received. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you format data that is part of a drop down menu? | Excel Discussion (Misc queries) | |||
| Performance in excel 97 is poor | Excel Discussion (Misc queries) | |||
| format cell from data input to output form | Excel Worksheet Functions | |||
| excel data label format special number characters (part 2) | Excel Discussion (Misc queries) | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
Threaded Mode
