kojak43
Active Member
- Joined
- Feb 23, 2002
- Messages
- 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?
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?
