F
furquan
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 t
copy and paste cells A1 to E1 (the middle cell of my row) in a 'revers
order' with alternate blank cells, For example
A1,B1,C1,D1,E1,F1,G1,H1,I1,J1 should first becom
_,E1,_,D1,_,C1,_,B1,_A1 (its not starting with a blank, it is startin
with A1 from right to left hence ending with a blank on the extrem
left). Then for the rest of the cells F1 to J1, I want to paste them i
those alternate blank cells in normal order. The resulting order woul
then be something like this F1,E1,G1,D1,H1,C1,I1,B1,J1,A1. The same ste
I want to repeat again on this new order and do it again and again unti
I get the original order. If data is small say twenty cells longs the
it would take 10 rearrangements to get the original order. I've manage
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 10
rearrangements to get the original order and rearranging it manually i
really confusing and cumbersome.
If there is any method or formula I could incorporate to get my desire
results faster It would be really appreciated. Thanks a ton in advance
Furqua
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 t
copy and paste cells A1 to E1 (the middle cell of my row) in a 'revers
order' with alternate blank cells, For example
A1,B1,C1,D1,E1,F1,G1,H1,I1,J1 should first becom
_,E1,_,D1,_,C1,_,B1,_A1 (its not starting with a blank, it is startin
with A1 from right to left hence ending with a blank on the extrem
left). Then for the rest of the cells F1 to J1, I want to paste them i
those alternate blank cells in normal order. The resulting order woul
then be something like this F1,E1,G1,D1,H1,C1,I1,B1,J1,A1. The same ste
I want to repeat again on this new order and do it again and again unti
I get the original order. If data is small say twenty cells longs the
it would take 10 rearrangements to get the original order. I've manage
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 10
rearrangements to get the original order and rearranging it manually i
really confusing and cumbersome.
If there is any method or formula I could incorporate to get my desire
results faster It would be really appreciated. Thanks a ton in advance
Furqua