| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rearrange data from columns to rows
Can someone help me with a way to quickly rearrange data from columns to rows
on a large amount of data. Need to take data that looks like this.... C1 C2 C3 R1 User name guest1 R2 Membership *dcl_r *ks R3 Membership *global_rw *global_r R4 Membership *contributor *cdc_rwd R5 User name guest2 R6 Membership *dcl_rw *kst R7 Membership *global_r *global_rwd and make it look like this...... C1 C2 C3 R1 guest 1 *dcl_r R2 guest 1 *ks R3 guest 1 *global_rw R4 guest 1 *global_r R5 guest 1 *contributor R6 guest 1 *cdc_rwd R7 guest2 *dcl_rw R8 guest2 *kst R9 guest2 *global_r R10 guest2 *global_rwd |
| 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) | |||
| Rearrange data in columns | Excel Discussion (Misc queries) | |||
| Rearrange data into other columns | Excel Discussion (Misc queries) | |||
| Rearrange two columns of data | Excel Discussion (Misc queries) | |||
| Rearrange info in rows to columns - HELP! | Excel Discussion (Misc queries) | |||
Threaded Mode
