Flip Cells

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

Guest

Wondering how to take info in a number of rows and flip the rows so that row
100 is now row 1 and row 1 has row 100s information. Not sure if a macro
would be better (don't know the code) or is there a simple excel function
that does this.
 
Simplist way would be


Insert a column to the left of your list.
in the first cell of the column put the number 1
In the second cell put the number 2
drag this dow for all 100 rows

do a sort on the new list (including the new column) and sort on the first
column descending.
 
Hi
in a helper cell in B1 enter the formula
=OFFSET($A$100,-(ROW()-1),0)
and copy this down
Afterwards copy this column and use 'Edit - Paste Special - Values' to
remove the formulas
 
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

Excel Fit to page print options in Excel 1
"Flipping" a matrix 7
Adjusting height of text cells 3
Border formatting row of cells 22
macro to show / hide grouping, linked to label button 3
Changes in How Code Acts After Upgrade of Excel 2
VBA CreateNames (ignores last 5 rows?) 6
Display selected cell at bottom of screen 2

Back
Top