L
Lynz
Hi, I am using excel 2003 and trying to help out a local pony club.
I have a worksheet with lists of data that I need to rearrange to print.
I have no choice in the layout. Data is in columns C,D, G,I
There are different number of entrants in each class, the classes are
numbered.
# Class Pony Rider
1 Hunter Molly John Smith
1 Hunter Pixie Mary Jones
1 Hunter Patch Ellie Martini
2 Jumper Pixie Mary Jones
2 Jumper Patch Ellie Martini
3 Trott Molly John Smith
3 Trott Pixie Mary Jones
3 Trott Sparkle Ann Munroe
3 Trott Patch Ellie Martini
etc.. I need to have it look like this and with a gap between each class
1 Hunter
Molly John Smith
Pixie Mary Jones
Patch Ellie Martini
2 Jumper
Pixie Mary Jones
Patch Ellie Martini
3 Trott
Molly John Smith
Pixie Mary Jones
Sparkle Ann Munroe
Patch Ellie Martini
Would I use bigger row heights to make the gaps? or insert rows? It
would be great to know how to do either . I have tried recording a macro
but as the numbers in the class vary, the ranges vary each time, but the
heaadings etc will be in the same relative place. I am a bit lost, any
help would be much appreciated thank you.
Lyn
I have a worksheet with lists of data that I need to rearrange to print.
I have no choice in the layout. Data is in columns C,D, G,I
There are different number of entrants in each class, the classes are
numbered.
# Class Pony Rider
1 Hunter Molly John Smith
1 Hunter Pixie Mary Jones
1 Hunter Patch Ellie Martini
2 Jumper Pixie Mary Jones
2 Jumper Patch Ellie Martini
3 Trott Molly John Smith
3 Trott Pixie Mary Jones
3 Trott Sparkle Ann Munroe
3 Trott Patch Ellie Martini
etc.. I need to have it look like this and with a gap between each class
1 Hunter
Molly John Smith
Pixie Mary Jones
Patch Ellie Martini
2 Jumper
Pixie Mary Jones
Patch Ellie Martini
3 Trott
Molly John Smith
Pixie Mary Jones
Sparkle Ann Munroe
Patch Ellie Martini
Would I use bigger row heights to make the gaps? or insert rows? It
would be great to know how to do either . I have tried recording a macro
but as the numbers in the class vary, the ranges vary each time, but the
heaadings etc will be in the same relative place. I am a bit lost, any
help would be much appreciated thank you.
Lyn