I have a large list of names and addresses that when imported into excel
comes in without being in the proper columns (name, address, city, state,
etc). To fix this I need to select and copy the data in every eighth row
(A3, A11, A19, A27, etc.) and paste this into a name column. Is there a way
to do this automatically without clicking on every cell individually?

Let's say you want column M to be your name column (this might be on
another sheet). Put this formula in M3:

=INDIRECT("Sheet1!A"&(ROW(A1)-1)*8+3)

then copy this down. I've assumed your data is on Sheet1.

Hope this helps.

Pete

On Apr 9, 4:32*pm, jdpf wrote:
I have a large list of names and addresses that when imported into excel
comes in without being in the proper columns (name, address, city, state,
etc). *To fix this I need to select and copy the data in every eighth row
(A3, A11, A19, A27, etc.) and paste this into a name column. *Is there a way
to do this automatically without clicking on every cell individually?

Thanks "Pete_UK" it worked great.

"Pete_UK" wrote:

Let's say you want column M to be your name column (this might be on
another sheet). Put this formula in M3:

=INDIRECT("Sheet1!A"&(ROW(A1)-1)*8+3)

then copy this down. I've assumed your data is on Sheet1.

Hope this helps.

Pete

On Apr 9, 4:32 pm, jdpf wrote:
I have a large list of names and addresses that when imported into excel
comes in without being in the proper columns (name, address, city, state,
etc). To fix this I need to select and copy the data in every eighth row
(A3, A11, A19, A27, etc.) and paste this into a name column. Is there a way
to do this automatically without clicking on every cell individually?