| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose columns to rows using first columns repeated. | Excel Worksheet Functions | |||
| repeating columns containing rows going beyond the repeated column | Excel Discussion (Misc queries) | |||
| How to make columns based on repeated rows?? | Excel Discussion (Misc queries) | |||
| single table with columns that have different amounts of rows | New Users to Excel | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
Threaded Mode
