Is there a way to reverse the layout of your colums?

[Guest]

If you have columns with data from A - BB, is there a way to reverse the
columns so BB data is now A and so on?

 

[Chip Pearson]

Suppose your data is in A1:BB1. Enter the following array formula
in A2, and fill across to BB1

=OFFSET($A$1:$BB$1,0,MAX(COLUMN($A$1:$BB$1))-COLUMN())

Since this is an array formula, you must press Ctrl+Shift+Enter
rather than just Enter when you first enter the formula and
whenever you edit it later. If you do this properly, Excel will
display the formula enclosed in curly braces {}.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[RagDyer]

One way.

Insert a new row, say a new Row1.
Number it from 1 to 54 - A to BB.
Now, select A1,
Navigate to the last cell in BB,
Hold <Shift>, and click in that last cell.

While your entire list is still selected,
<Data> <Sort> <Options>
And click
"Sort Left To Right"
<OK>
Make sure the "Sort By" window shows "Row1"
Click on "Descending",
<OK>

And you should have what you asked for.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================