Sorting - Interlacing

[Kreppie]

Hi,

Does excel have a possibility to interlace data in stead of sorting them the conventional way?

I mean like this;
Suppose you have data

A
B
B
A

If you sort them, they become:
A
A
B
B

but what I want is:

A
B
A
B

Any Solutions?

[AlKey]

I am not sure where this is going but, for this particular example try this formula

in B1 and copy it down

=INDEX($G$1:$G$6,MOD(ROWS($A$1:A1)-1,2)+1)

	A	B
1	A	A
2	B	B
3	B	A
4	A	B

[MrShorty]

I would be tempted to add a helper column that counts the number of A's and B's above that row. Something like =COUNTIF($A$1:A1,A1) [note the mix of relative and absolute referencing to control the input range.] http://office.microsoft.com/en-us/ex...077.aspx?CTT=1

Then a two key or two level sort where the first key is this helper column (increasing from 1 to whatever) and the 2nd key is column A (the column containing the A's and B's).

[newdoverman]

Something like this could work. It is a modification of MrShorty's solution

In column B enter this formula and copy down then select all the data and do 1 sort on column B:

Please Login or Register  to view this content.

Result:

	A	B	C
1	a	1a	=COUNTIF($A$1:A1,A1)&A1
2	b	1b
3	a	2a
4	b	2b
5	a	3a
6	b	3b
7	a	4a
8	b	4b
9	a	5a
10	b	5b