Excel help please ?

[Snow-Munki]

Hi,

I have a spreadsheet with data in D14 / F14 / H14 / J14 and so on. So all on the same row but just every other column.

What is the best way to get this as a list of data so on a different sheet the data is just in A1 / A2 / A3 / A4

Hope that makes sense ?

Thanks,

 

[Snow-Munki]

thanks, but in the original spreadsheet the data goes on for a while ( like 50 entries ! )

Must be a easy way to 'drag' the data down so it knows to choose D14 / F14 / H14 / J14

 

[Snow-Munki]

phew ! got it working in the end, thanks for your help !!