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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

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

How do I link data from a horizontal range to a vertical range? 3
Convert a 8X3 table to a vertical range of the Unique strings only 8
how to create a monthly chart with number of days 1
Change horizontal tables to vertical stacked tables? 1
How do I find where a column value and row value intersect? 2
How to create a double vertical line in a table 3
OL2007 - Sorting/Grouping by Categories - Creating a Custom Sort 1
how do i sort a spread sheet and remove duplication 3

Back
Top