I have an Excel spreadsheet that I need to have automatically edited. I do not know the formula to do this. Here is the scenerio:
Col 1 Col 2
Site Nbr Name
123456 Jane B
John A
George A
Georgia B
All of the above Names need to have the same site number recorded in Col 1 to identify the name with the Site Nbr. The above example is only one group. There are several other groups like this one that has different Site Nbrs for each group. There are also over 2000 rows. This spreadsheet has been exported from another site, so I can only change it from my end.
I know I can copy the Site Nbr and paste it in the rows below, but with over 2000 rows, and different groups in between, this takes a lot of time.
I would like to have a formula for Excel to fill in Col 1 for me.
I am running Vista & Win7, and Office 2007 & 2010 (on different pc's). Thank you for any help you can give me.
Col 1 Col 2
Site Nbr Name
123456 Jane B
John A
George A
Georgia B
All of the above Names need to have the same site number recorded in Col 1 to identify the name with the Site Nbr. The above example is only one group. There are several other groups like this one that has different Site Nbrs for each group. There are also over 2000 rows. This spreadsheet has been exported from another site, so I can only change it from my end.
I know I can copy the Site Nbr and paste it in the rows below, but with over 2000 rows, and different groups in between, this takes a lot of time.
I would like to have a formula for Excel to fill in Col 1 for me.
I am running Vista & Win7, and Office 2007 & 2010 (on different pc's). Thank you for any help you can give me.