View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jack jack is offline
external usenet poster
 
Posts: 186
Default Create list based on data table

i would like to create a list based on the data in a table.

A B C
Num Item Price
3 Coats $25.00
2 Hats $10.00
4 Gloves $2.00

the output should like like the following
Coats $25.00
Coats $25.00
Coats $25.00
Hats $10.00
Hats $10.00
Gloves $2.00
Gloves $2.00
Gloves $2.00
Gloves $2.00

thanks for your help
Jack