View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TouchTone TouchTone is offline
external usenet poster
 
Posts: 4
Default Sorting with matching header

Hi

I need some solutions to the following. Please help.

Original

Supplier 1 Supplier 2 Supplier 3 .......
Product 1 5 10 15
Product 2 10 8 9
Product 3 15 25 4
..
..
..
Sort Results wanted to be as show

Product 1 Supplier 1, Supplier 2, Supplier 3
Product 2 Supplier 2, Supplier 3, Supplier 1
Product 3 Supplier 3, Supplier 1, Supplier 2


--
TouchTone Support