Hi,
I have a set of data in range(B1:E20).
In row (B1:E1) there are numbers 1 to 4 in this order 2,1,4,3.
I would like to rearrange the columns so that column B is the one which has number 1 then column C has number 2 then column D has number 3 and column E has number 4.
Basically the columns have to be 'sorted' in ascending order based on their numbers in row 1.
How do I do that?
Thanks,
Nic

I have a set of data in range(B1:E20).
In row (B1:E1) there are numbers 1 to 4 in this order 2,1,4,3.
I would like to rearrange the columns so that column B is the one which has number 1 then column C has number 2 then column D has number 3 and column E has number 4.
Basically the columns have to be 'sorted' in ascending order based on their numbers in row 1.
How do I do that?
Thanks,
Nic
