I am trying to format a report in an excel spreadsheet where each record in the original report takes up several rows of various sizes. Some records are only 1 row, others are up to 4 rows of data. While most of the record data (10 fields) are in the first row, 3 fields (quantity, item and cost) can have multiple entries each on their own row.
How can I arrange to move all the record data onto the first row so that each record takes up one only row?
Bookmarks