Selecting non-adjacent data

[jdpf]

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?

 

[Pete_UK]

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

 

[jdpf]

Thanks "Pete_UK" it worked great.

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