How do I sort a horizontal worksheet to create a vertical table

T

The Hamburger36

In XP (WIN2000) I need to sort items in a vertical column (Results), taken
from a weekly schedule Mon thru SAT; these days are listed side by
side(horizontally) each day having o to 8 entries (vertically). The Results
column should list items one after the other, leaving no blanks or duplicates.
Daily items fall either into category one or two followed with an account
number.
The desired end result will be two tables, #1 and #2 each listing account #
and date.
Any assistance would be greatly appreciated
 
P

Peo Sjoblom

I am not sure I understand, do you just want the table flipped vertically?
If so copy the table, select a cell outside the range and do edit>paste
special and select transpose
To remove duplicates first use advanced filter, to remove blanks just select
the table, press F5 and select blanks, press ctrl + - (hyphen/minus)and
delete entire row if the whole row is empty
 
Top