data won't repeat names in column. example
A1=my name B1-B13 various data for me
A14=your name B14-B23 various data for you

how do I get my name in A2-A13 and yours in A14-A23?

it's never the same names or rows of data.

Thank you very much!