How to Reverse a Column Order in Excel

[Nilesh_kamble]

Dear All,

Please let me know how to reverse a column in excel.

for example I have below data,

E	D	C	B	A
17	13	9	5	1
18	14	10	6	2
19	15	11	7	3
20	16	12	8	4

<tbody>
</tbody>

And same would be change in to below data

A	B	C	D	E
1	5	9	13	17
2	6	10	14	18
3	7	11	15	19
4	8	12	16	20

<tbody>
</tbody>

 

[NinadM]

Try this formula:

=IFERROR(INDEX($A1:$E1,1+COUNTA($A1:$E1)-COLUMNS($A1:A1)),"")

 

[hetfieldkaloo]

Quick workaround is : Add a row above the column names and number them 5,4,3,2,1 respectively --- select the entire table ---goto sort ---Options----sort left to right---sort by row 1 ---smallest to largest
Delete row 1
im sure you can write a code to rearrange the column numbers but this works faster for me.

 

[Nilesh_kamble]

Quick workaround is : Add a row above the column names and number them 5,4,3,2,1 respectively --- select the entire table ---goto sort ---Options----sort left to right---sort by row 1 ---smallest to largest
Delete row 1
im sure you can write a code to rearrange the column numbers but this works faster for me.

It's Working sir thanks a lot