Test Data upside down

[Sandie1712]

Hi

I want to reverse the direction of my data i.e i want it's upside to be down...........No VBA pl

e.g

Actual Data			Required Resuls
Sachin			Dravid
Virat			Rahul
Dhoni			Jadeja
Gavaskar			Kapil
Kapil			Gavaskar
Jadeja			Dhoni
Rahul			Virat
Dravid			Sachin

<colgroup><col span="3"><col></colgroup><tbody>
</tbody>

Looking forward for the solution ...

With Warm Regards

Sandeep

 

[Eric W]

Try:

	A	B	C
1	Actual Data		Required Resuls
2	Sachin		Dravid
3	Virat		Rahul
4	Dhoni		Jadeja
5	Gavaskar		Kapil
6	Kapil		Gavaskar
7	Jadeja		Dhoni
8	Rahul		Virat
9	Dravid		Sachin

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet5​

Worksheet Formulas Cell Formula C2 =OFFSET($A$2,COUNTA(A:A)-ROW(),0) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Sandie1712]

Thank You!!

 

[Peter_SSs]

Here's another option that I think has some advantages.
1. I generally try to avoid volatile functions if it is easily done - which it is here.
2. If you happen to have any blank cells within the original data, this returns a list that is "less wrong" (can be adjusted).
3. If any new rows are subsequently inserted above the list, this will still give the correct results.

Excel Workbook
	A	B	C
1	Actual Data		Required Resuls
2	Sachin		Dravid
3	Virat		Rahul
4	Dhoni		Jadeja
5	Gavaskar		Kapil
6	Kapil		Gavaskar
7	Jadeja		Dhoni
8	Rahul		Virat
9	Dravid		Sachin
Reverse