| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting database generated report to raw data
I have a report in the format of:
Animal (1st level Category) Mammal (2nd level Category) Human (3rd level Category) entries.... entries.... entries.... Human Total Apes entries... entries... Apes Total Mammal Total ....... How can I convert all 3 levels category back to the entries like column A shows Animal (1st level), column B shows (2nd level) and column C shows (3rd level) and delete all those total for ease of vlookup? Thanks in Advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros VBA and Converting Form to Database | Excel Discussion (Misc queries) | |||
| Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
| works database - converting | Excel Discussion (Misc queries) | |||
| converting from works database | Excel Discussion (Misc queries) | |||
| Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) | |||
Threaded Mode
