Hi there,

I have a long data in a single row which I want to arrange differently. Say, I have alphabets (including repeating) from A1 to J1, I want to copy and paste cells A1 to E1 (the middle cell of my row) in a 'reverse order' with alternate blank cells, For example, A1,B1,C1,D1,E1,F1,G1,H1,I1,J1 should first become _,E1,_,D1,_,C1,_,B1,_A1 (its not starting with a blank, it is starting with A1 from right to left hence ending with a blank on the extreme left). Then for the rest of the cells F1 to J1, I want to paste them in those alternate blank cells in normal order. The resulting order would then be something like this F1,E1,G1,D1,H1,C1,I1,B1,J1,A1. The same step I want to repeat again on this new order and do it again and again until I get the original order. If data is small say twenty cells longs then it would take 10 rearrangements to get the original order. I've managed to do it manually (by taking A2=F1, B2=E1, C2=G1, and so on....). However, when my data is long say 105 cells long then it would take 105 rearrangements to get the original order and rearranging it manually is really confusing and cumbersome.

If there is any method or formula I could incorporate to get my desired results faster It would be really appreciated. Thanks a ton in advance.

Furquan