View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ferdi ferdi is offline
external usenet poster
 
Posts: 1
Default How to convert a table to list?

Can anybody help me to convert a table to a list?

For example:

Table:
Red Black
VW 100 20
Toyota 15 50

to become:

List:
VW Red 100
VW Black 20
Toyota Red 15
Toyota Black 50

Thank you