Thread
:
Sort a Table into one long list
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Sort a Table into one long list
A looping macro that looked at each number and used the left column and the
top row to add to it.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Stoke" wrote in message
...
I have a table with row and column headings. Basically it's a grid of
prices
for styles and materials. I'd like to sort those prices and have the row,
column headings displayed next to the list - sort of like this
cherry ash oak
plain 12.50 10 11.75
fancy 19.50 12 15
sorting into this
10 plain, ash
11.75 plain oak
12 fancy ash
12.50 plain cherry
15 fancy oak
19.50 fancy cherry
Is it possible? What's the right tool? Is Excel the right place? THanks
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett