Thread: repeated rows to single rows with many columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
geanswerman geanswerman is offline
external usenet poster
  
Posts: 1
Default repeated rows to single rows with many columns
Below is shown an extracted table that I need to rearange to show price list.

Material Description Minimum_Qty Sell_Price
10001 Screw,IF,Can,Ti,7X20 1 90
10001 Screw,IF,Can,Ti,7X20 11 83.5
10001 Screw,IF,Can,Ti,7X20 21 76.5
10002 Screw,IF,Can,Ti,7X25 1 90
10002 Screw,IF,Can,Ti,7X25 11 83.5
10002 Screw,IF,Can,Ti,7X25 21 76.5

Material Description 1 11 21
10001 Screw,IF,Can,Ti,7X20 90.00 83.50 76.50
10002 Screw,IF,Can,Ti,7X25 90.00 83.50 76.50


Is this possible? I thought I had done it before but I can not find a
reference for it.
Reply With QuoteReply With Quote