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






"Jess" wrote in message
...
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?