How 2 reverse order of columns

B

Bill Meacham

I want to reverse the order of columns in a worksheet. Specifically, someone
has sent me a file of utility usage data in which the most recent date is in
column B and the oldest date is in column M. I want to reverse that, putting
the most recent date in M and the earliest in B. Is there a way to do this
without manually cutting and pasting?
 
N

Niek Otten

Yes. Data>Sort, click Options, and then Left to Right, OK, Descending

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
B

Bill Meacham

Great! Thanks!

Niek Otten said:
Yes. Data>Sort, click Options, and then Left to Right, OK, Descending

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
Click to expand...
 
J

Jim May

Here's a small example:
*** Try this on a copy of your file, NOT The Original !! ***

WIth your dates (like you say) in a limited range, say B5:M50.

Drop down to the bottom of the worksheet and clear of the used area
where there's nothing below, say Row 105 and in cell
B105 enter =OFFSET($B5,0,13-COLUMN(),)
then copy and paste to cells C105:M105
then copy C105:M105 and paste to C106:M150

The dates now in C105:M150 will be what you want,
except their not where you want them; Highlight
C105:M150, Copy (it) then point to cell B5 and
do a Paste-Special Values. It may be necessary to
Format the Range B5:M50 to the desired date
format you want.

Hope this helps,,,
Jim May
 
Top