Grouping multiple rows

  • Thread starter Thread starter Michael Korman
  • Start date Start date
M

Michael Korman

I am trying to make a report in Excel from data that
was taken from a database. I have two worksheets. The
first contains my raw data, which is in the form of
one row per record. The second is my report. In the
report, I would like to have multiple rows for each
record, so that I can conserve horizontal space. There
are two things I would like to do:

1) Sort my records by some field.
2) Autofill all of my records down the whole worksheet.

Both of these are hard to do because I want to use 3 lines
for each item, instead of one. If I fill in the references
to the raw data worksheet for the first item, and then
drag, it fails because it thinks each row is its own item.
Same problem with sorting.

How do I get around this?
 
Hi Michael,
Create two helper columns will be on each row, that you can delete after sorting
- sort field
- number the rows (not a formula), place a 1 at top
and file down.

Sort on sort field ascending then on the number
 
Back
Top