If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
Rearrange data from columns to rows
In EXCEL 2007 do the following:-
1. Highlight the data that you with to switch. 2. Ctrl-C to copy the data. 3. Move to an (new) area where you wish the amended data to appear (perhaps a new Worksheet?). 4. Home tab / Clipboard / Paste / Transpose. This should give you what you want. Youy may also like to do a search on:- rows to columns - where Microsoft explain the above. If my comments have helped please hit Yes. Thanks! "pikeda" wrote: 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 | |
Display Modes | |
|
|