flip table

M

Mike H

Hi,

In a helper column alongside your table enter the numbers 1,2,3 etc and drag
down to the length of your table. Select all the columns including the helper
column then:-

Data|Sort [select the helper column]
select descending
OK

Delete the helper column.

Mike
 
B

Bob I

As in make column C to be Column A and Column A to be Column C?

R-click C, Cut, R-click A, Insert cells, R-click C, Cut, R-Click B,
Insert cells
 
N

Nastech

Mike H said:
Hi,

In a helper column alongside your table enter the numbers 1,2,3 etc and drag
down to the length of your table. Select all the columns including the helper
column then:-

Data|Sort [select the helper column]
select descending
OK

Delete the helper column.

Mike

googooli said:
How can I flip the columns of table?
 

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

Top