| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting database generated report to raw data
The only difference of the category items and total are they are in "Bold"
formats. "Thomas" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting database generated report to raw data
Hi,
Is there anyone who could provide some help on this? Thanks "Thomas" wrote: The only difference of the category items and total are they are in "Bold" formats. "Thomas" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting database generated report to raw data
Is this an Excel question or an Access question? If an Excel question, then
a little more information as to what the data looks like in Excel, and what you mean by "raw data". "Thomas" wrote in message ... Hi, Is there anyone who could provide some help on this? Thanks "Thomas" wrote: The only difference of the category items and total are they are in "Bold" formats. "Thomas" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting database generated report to raw data
Hi Latham,
This is an excel question. My company have crystal report run SQL and generated a report in excel format. The file contains: ============================================= Column A Column B Column C Animal (// In bold format, which is the 1st level Category of below data) Mammal (// In bold format, which is the 2nd level Category of below data) Human (// In bold format, which is the 3rd level Category of below data) US People Male 200000 US People Female 210000 Canada People Male 150000 Canada People Female 140000 Human Total (// In bold format, which states the end of 1 of the 3rd level Category of data) Mouse (// in bold too, under 2nd Mammal, start) England Mouse Male 100000000 England Mouse Female 200000000 Mouse Total (// In bold, closing Mouse category) Mammals Total (//In bold, closing mammal 2nd category) Animal Total (// in bold, closing animal 1st category) ============================== I need to find some method who could give me to "insert" back the category name into the entries like: Animal Mammal Human US People Male 200000 on the same row so that I could easily doing some vlookups. All the categories are no more than 3 levels. But the data are in tonnes, making hand-by-hand doing this is no easy (awful) task. I hope you or someone who could really help me out in this hell situation. Thanks a lot "JLatham" wrote: Is this an Excel question or an Access question? If an Excel question, then a little more information as to what the data looks like in Excel, and what you mean by "raw data". "Thomas" wrote in message ... Hi, Is there anyone who could provide some help on this? Thanks "Thomas" wrote: The only difference of the category items and total are they are in "Bold" formats. "Thomas" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting database generated report to raw data
Hi,
Is there anybody able to help? Thanks "Thomas" wrote: Hi Latham, This is an excel question. My company have crystal report run SQL and generated a report in excel format. The file contains: ============================================= Column A Column B Column C Animal (// In bold format, which is the 1st level Category of below data) Mammal (// In bold format, which is the 2nd level Category of below data) Human (// In bold format, which is the 3rd level Category of below data) US People Male 200000 US People Female 210000 Canada People Male 150000 Canada People Female 140000 Human Total (// In bold format, which states the end of 1 of the 3rd level Category of data) Mouse (// in bold too, under 2nd Mammal, start) England Mouse Male 100000000 England Mouse Female 200000000 Mouse Total (// In bold, closing Mouse category) Mammals Total (//In bold, closing mammal 2nd category) Animal Total (// in bold, closing animal 1st category) ============================== I need to find some method who could give me to "insert" back the category name into the entries like: Animal Mammal Human US People Male 200000 on the same row so that I could easily doing some vlookups. All the categories are no more than 3 levels. But the data are in tonnes, making hand-by-hand doing this is no easy (awful) task. I hope you or someone who could really help me out in this hell situation. Thanks a lot "JLatham" wrote: Is this an Excel question or an Access question? If an Excel question, then a little more information as to what the data looks like in Excel, and what you mean by "raw data". "Thomas" wrote in message ... Hi, Is there anyone who could provide some help on this? Thanks "Thomas" wrote: The only difference of the category items and total are they are in "Bold" formats. "Thomas" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
