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

Rearrange data from columns to rows
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pikeda" wrote in message
...
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

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