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.
Last edited by shejintr; 03-18-2012 at 05:58 AM.
If the range is in A1:A20, then try:
=INDEX($A1:$A$20,5*(COLUMNS($A$1:A$1)-1)+1)
copied down 5 rows and across 4 columns.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
@NBVC:
this formula would not prevent same A's or B's etc. from appearing along the same row. how to achieve that?
thanks and regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks