Excel Report

kojak43 · Mar 6th, 2002, 03:29 PM

Is there a way to produce a report in Excel where data under a column head gets sorted and, in the report, the data shows up as "row headers" with specific data beneath. For example, I have a field called "Category" Under the name I have several categories (duhh). What I want to do is sort the "categories" so all are grouped alphabetically. That is Category "A" might have six different job#'s and Job Descriptions. Category "B" might have ten Job 3's and Descriptions.
I want Category "A" to appear as a row header with six jobs listed below and category "B" with ten jobs.
I can produce the report if I open Access and import the data, then have Access make the report.

I would prefer if I can keep it in Excel. Can it be done?

lenze · Mar 6th, 2002, 03:35 PM

Use a Pivot Table Report?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 03:29 PM	#1
kojak43 Board Regular Join Date: Feb 2002 Posts: 270	Is there a way to produce a report in Excel where data under a column head gets sorted and, in the report, the data shows up as "row headers" with specific data beneath. For example, I have a field called "Category" Under the name I have several categories (duhh). What I want to do is sort the "categories" so all are grouped alphabetically. That is Category "A" might have six different job#'s and Job Descriptions. Category "B" might have ten Job 3's and Descriptions. I want Category "A" to appear as a row header with six jobs listed below and category "B" with ten jobs. I can produce the report if I open Access and import the data, then have Access make the report. I would prefer if I can keep it in Excel. Can it be done?

Mar 6th, 2002, 03:35 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Use a Pivot Table Report?