sorting issue - simple but annoying!

drunkbynoon65

New Member
Joined
Mar 18, 2011
Messages
1
Hi,

I have a simple yet infuriating issue! I am trying to sort data that's grouped together in 3 rows across a number of columns, however because the 3 rows at Column A are expanded to make one row, when I sort the data it only shows the top line of the three lines I want to show?

I'm sure there is a quick way of sorting this but I can't work it out.

Would very much appreciate some kind advice! thanks.
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Ruddles

Well-known Member
Joined
Aug 24, 2010
Messages
5,785
If you are sorting data which has multiple rows per 'record' and you want to keep the rows in each record together, you will need to add a sort key to each row indicating which record it belongs to and whether it's the first, second or third row of the record.

If that doesn't help, I think you need to show us the worksheet.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,205
Messages
5,527,402
Members
409,760
Latest member
zeeshansyed

This Week's Hot Topics

Top