Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting and grouping data with varying number or rows
I have a large spreadsheet that is downloaded from another site.
Is there a formula to group rows from 'header' to next header? I need to group 4 rows and then the corresponding data for the header rows which varying in the number of rows e.g. Header group Date Service Code Name Corresponding data: next 5 rows Next header (as indicated above) can have 25 rows, etc. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting and grouping data with varying number or rows
Have you tried using a Pivot Table? A Pivot Table will do both the sorting
and grouping. http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.babeled.com/2008/07/18/ex...-manipulation/ -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Vickie" wrote: I have a large spreadsheet that is downloaded from another site. Is there a formula to group rows from 'header' to next header? I need to group 4 rows and then the corresponding data for the header rows which varying in the number of rows e.g. Header group Date Service Code Name Corresponding data: next 5 rows Next header (as indicated above) can have 25 rows, etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting rows of data of varying lengths | Excel Discussion (Misc queries) | |||
How do I make a chart take into account a varying number of rows? | Charts and Charting in Excel | |||
copy data from varying slected rows into new spreadsheet | Excel Discussion (Misc queries) | |||
Formatting/Totalling Macro with varying rows of data | Excel Discussion (Misc queries) | |||
Sorting while grouping 3 rows together... | Excel Discussion (Misc queries) |