how to reposition the dataset from top to bottom in a column?

A

arizona

I need to change the datas from top to bottom position or reverse the
position of dataset without doing the ascending or descending order of the
dataset.
 
R

RagDyer

If data in B1 to B20, try this in C1, and copy down to C20:

=INDEX($B$1:$B$20,20-(ROW(A1)-1))
 

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

Format column widths from one table to a separate table on same page 1
Help in Median of a quartile 4
Data consolidation 0
Compare two datasets and extract unique records from each 3
How to save a PDF with header that extends to edge of page? 3
Move Chart with Text 0
sort and select based on criteria 1
Dataset view reversal, new record on top 3

Top