copy and pasting in 5000 records referencing cells

  • Thread starter Thread starter Fawn Lagimodiere
  • Start date Start date
F

Fawn Lagimodiere

I have a file that is 5000 records long.

example

Column A Column B
namea
nameb
namec
Transit number associated with (a,b,c)

What I want is to have transit number appear in Column a beside each of the
individuals.

The issue is the transit number is different for all 5000 records some may
have 5 per transit number and others just 3 and some have 7 depending on
size of the branch.

Is there a formula to populate this without copy and pasting in each cell?

thanks
 
Back
Top