Shifting Row to Columns, Is it possible?

  • Thread starter Thread starter Mary K. Bullock
  • Start date Start date
M

Mary K. Bullock

I have a student who has a rather large spreadsheet and needs to extract
data using the Top N function with Autofilter...The problem is...The
criteria that he would like to use to determine the Top N values is the row
information instead of the column information. Is there a way to "transfer"
or relocate his row values to his columns values and vice versa? If not, is
there a way to perform a Top N function on the row data rather than the
column data?

The students data is Nasdaq stock abbreviations as his column headers and
dates from Jan, 2000 through today. The spreadsheet data is how each stock
performed on any given day over the last 4 years. He would like to be able
to know which were the Top 5 producing days out of the period of time.
 
If there are four years of data, you can't transpose rows and columns,
because there are only 256 columns.

Select a cell in the table, and choose Data>Filter>AutoFilter
To find the top five days for any stock, click the arrow in
column heading
Choose Top 10
Choose Top 5 Items, click OK

The list will be filtered for the top 5 (more if there is a tie)
 
Back
Top