Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sort a horizontal worksheet to create a vertical table
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 |
#2
|
|||
|
|||
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 editpaste 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 -- Regards, Peo Sjoblom "The Hamburger36" <The wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
How do I create a validation list on a separate worksheet? | Excel Worksheet Functions |