You'll want to setup a PivotTable (Data-Pivot) with Material & Description as
Row field, Qty as you column field and Sell_Price as your data field. This
should arrange your data the way you desire.

Note that you could then copy the data out of the PivotTable, if you wish to
make it static/save on file space.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"geanswerman" wrote:

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.