Flipping Data In Excel

[dustin_payne]

Hi, is there a way in Excel to flip the data that is in a column. I dont want it sorted accending or decending, just flipped.


for example:

12
43
9

to

9
43
12

Thanks,


Dustin

 

[izzy]

I'd just add a column and fill numbers 1 through 1000 (whatever) alongside your data. Then sort by the numbers I added. That would flip your data range and leave it in the order it's in.

 

[phantom1975]

Do you want a formula or a macro?

 

[Ekim]

Your original list in column A, in column B put:

=INDEX(A:A,COUNTA(A:A)+1-ROW())

Flipping or Reverse data in a column.xls
	A	B	C	D
1	12	3
2	34	1
3	10	24
4	24	10
5	1	34
6	3	12
7
Sheet1

or, you could use offset:

Flipping Order of Range without sorting.xls
	A	B	C	D	E	F
1
2
3	100	110		=OFFSET($A$3,13-ROW(),0)
4	200	450
5	300	600
6	50	500
7	70	400
8	60	60
9	400	70
10	500	50
11	600	300
12	450	200
13	110	100
14
Sheet1

HTH

Mike

 

[acw]

Hi

Or a macro. Highlight the range and run

Sub aaa()
Dim arr As Variant
arr = Selection.Value

Selection.Resize(1, 1).Select
For i = UBound(arr) To LBound(arr) Step -1
ActiveCell.Value = arr(i, 1)
ActiveCell.Offset(1, 0).Select
Next
End Sub

Will overtype existing values in place

Tony

 

[izzy]

Book1
	A	B	C	D	E	F
9					Sortedby
10	1	12			3	9
11	2	43			2	43
12	3	9			1	12
13
14		to				to
15
16		9				9
17		43				43
18		12				12
Sheet1

 

[dustin_payne]

Thanks everyone!

 

[Esther Parris]

Do you know how to flip data in rows rather than columns?

 

[fairwinds]

As example by changing Ekim's first formula:

Book2
	A	B	C	D	E	F	G
1	4	5	6	7	8	9	10
2	10	9	8	7	6	5	4
3
Sheet3