I have a single column of 20 data as shown below
A1
B1
C1
A2
B2
C2
A3
B3
C3
A4
B4
C4
A5
B5
C5
A6
B6
C6
A7
B7
How can I split it into 4 Columns as shown below
A1 C2 B4 A6
B1 A3 C4 B6
C1 B3 A5 C6
A2 C3 B5 A7
B2 A4 C5 B7
Same As or Bs or Cs or Ds should not come on adjuscent cells in same row.
Bookmarks