| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rearrange the data with a new table
I would like to transform my existing table A to table B.
Therefore, I can sort table B by customers for the subtotal. Thanks. KS Table A Name A D E B A F C E C 12 4 55 33 422 431 22 45 45 Table B name amount A 12 B 33 C 22 D 4 A 422 E 45 E 55 F 431 C 45 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to take data from one table and rearrange columns into new ta | Excel Discussion (Misc queries) | |||
| EXcel 2002: How to rearrange data table ? | Excel Discussion (Misc queries) | |||
| rearrange data | Excel Discussion (Misc queries) | |||
| How do i rearrange pie chart without re-arranging source table? | Charts and Charting in Excel | |||
| Rearrange data columns in Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
