Sort a Table into one long list

[Stoke]

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

 

[Don Guillett]

A looping macro that looked at each number and used the left column and the
top row to add to it.

 

[Max]

One way to transform it with ease into the desired columnar listings

Assume your source table as posted is in Sheet1's A13
where B11 contains the 3 "wood" types: cherry, ash, oak
and in A2 down are: plain, fancy, etc

In another sheet, place:
In A2: =OFFSET(Sheet1!$B$2,INT((ROWS($1:1)-1)/3),MOD(ROWS($1:1)-1,3))
In B2: =OFFSET(Sheet1!$A$2,INT((ROWS($1:1)-1)/3),)
In C2: =INDEX(Sheet1!$B$1:$D$1,MOD(ROWS($1:1)-1,3)+1)

Select A2:C2, copy down as far as required to exhaust the source data
Adapt the "3" and the INDEX ref range: Sheet1!$B$1:$D$1
within the expressions to suit the no. of source cols for "wood" types
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik

 

[Herbert Seidenberg]

Excel 2007
No macro, no formulas:
http://www.mediafire.com/file/mwyy2mjzhx5/12_01_08a.xlsx

 

[Stoke]

Thank you so much - it is really amazing to me to be taught something by
someone across the world - and in minutes after I ask the question!

 

[Max]

Welcome, glad it got you going.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik