Autofill down a column using another sheet row data and skip one column each time

Hi
I have data on a workbook that is in a row across the columns but missing every other column. I need to return these value to another sheet but filling down the column and skipping the blank columns on the other sheet.

Sheet 1 Data A1, C1, E1, G1

Sheet 2 results values form Sheet 1 go to A1, A2, A3, A4 etc.

Regards

Originally Posted by JohnPollardMDD

Hi
I have data on a workbook that is in a row across the columns but missing every other column. I need to return these value to another sheet but filling down the column and skipping the blank columns on the other sheet.

Sheet 1 Data A1, C1, E1, G1

Sheet 2 results values form Sheet 1 go to A1, A2, A3, A4 etc.

Regards

Any help guys?