Reverse worksheet data by columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with data, lets say from columns A:Z.
I would like to flip this data by columns only. eg Z becomes A, Y becomes B,
X becomes C etc.

I'm thinking I should link it to a new sheet and adjust by formula. Can
anyone help.
Any other ideas also appreciated.

Bruce
 
Just sort the columns, Choose data_sort and in your options you can sort
left to right rather than top to bottom which is the default.

Regards

Dav
 
You may want to re-think this.

Dav's suggestion works fine if the data from Column A to Z is already
alphabetically arranged.

If not, perhaps you could try entering the numbers 1 to 26 across A to Z and
sort left to right on them.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

advance level of sorting data? by Ting 1
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Can I reverse the axes of a populated worksheet (X to Y, Y to X)? 4
Scrabble Value calculation for Welsh words 0
search function 2
Find match between cells and copy data 7
How to copy variable data from 2 worksheets into a seperate 3rdworksheet 12
Compare cells and copy columns after match 2

Back
Top