Excel Help

[Poweruser99]

Here is my problem which has me going in circles. I have a spread sheet with user data. This sheet is structured in a table format. There are 20,000 records.

Basically it is a table of users and the money they have spent. There are fields which specify the place money spent the amount spent and other details.
This is how it is structured.

NAME: ABCEFG

AMOUNT PLACE QUANTITY ETC
55 Maine 55
66 Tampa 23
69 NYC 65

The above would be a sample record for a user. I have over a 1000 users. What I would like to have is to copy the name field and make it into a seperate field like AMOUNT or PLACE. Copy and pasteing it manually would take forever. Also for each user, the source field to be copied from is different. Any ideas would be appreciated.

 

[coachdan]

You can use the fill handle to drag it down and that would be faster than copy/paste.

coachdan32

 

[Poweruser99]

No that would not work at all. Because I want it like a table I want to name to repeat with the transactions. Like I said copying and pasting it would take forever.