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
![Unsure :unsure: :unsure:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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