Within one worksheet, I have two ranges of data, Columns A – D and F – I. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
In another worksheet within the same workbook I need to sort and stagger the data by row based on Columns A’s and F’s values. Row 1 is a header row.<o></o>
<o></o>
RAW DATA<o></o>
A B C D E F G H I<o></o>
1 PN DESC CO $ PN DESC CO $ <o></o>
2 A1 SSS DD 5.00 B4 XXX EE 2.00<o></o>
3 A2 ABC EF 2.25 B5 DDD FF 3.25 <o></o>
4 B5 FFF GG .75 C1 RRR RR 1.35<o></o>
5 C1 GGG HH 1.22 C9 QQQ AB 6.96<o></o>
<o></o>
<o></o>
STAGGERED OUTPUT DESIRED
A B C D E F G H I
<o>1 PN DESC CO $ PN DESC CO $ <o></o></o>
2 A1 SSS DD 5.00 <o></o>
3 A2 ABC EF 2.25 <o></o>
4 B4 XXX EE 2.00<o></o>
5 B5 FFF GG .75 B5 DDD FF 3.25<o></o>
6 C1 GGG HH 1.22 C1 RRR RR 1.35<o></o>
7 C9 QQQ AB 6.96
<o></o>
<o></o>
I’m using Excel 2009. Can you offer a solution? <o></o>
Thanks in advance for your help.<o></o>
<o></o>
Ted <o></o>
fficeffice" /><o></o>In another worksheet within the same workbook I need to sort and stagger the data by row based on Columns A’s and F’s values. Row 1 is a header row.<o
></o><o
></o>RAW DATA<o
></o>A B C D E F G H I<o
></o>1 PN DESC CO $ PN DESC CO $ <o
></o>2 A1 SSS DD 5.00 B4 XXX EE 2.00<o
></o>3 A2 ABC EF 2.25 B5 DDD FF 3.25 <o
></o>4 B5 FFF GG .75 C1 RRR RR 1.35<o
></o>5 C1 GGG HH 1.22 C9 QQQ AB 6.96<o
></o><o
></o><o
></o>STAGGERED OUTPUT DESIRED
A B C D E F G H I
<o
>1 PN DESC CO $ PN DESC CO $ <o></o></o>2 A1 SSS DD 5.00 <o
></o>3 A2 ABC EF 2.25 <o
></o>4 B4 XXX EE 2.00<o
></o>5 B5 FFF GG .75 B5 DDD FF 3.25<o
></o>6 C1 GGG HH 1.22 C1 RRR RR 1.35<o
></o>7 C9 QQQ AB 6.96
<o
></o> <o
></o>I’m using Excel 2009. Can you offer a solution? <o
></o>Thanks in advance for your help.<o
></o><o
></o>Ted <o
></o>
