Copying formulas across 351 columns in excel

Hi all,

I wish to copy a formula across in excel leaving 2 blank columns after every set of data.

For Instance: in Sheet1 column A1 i have a value
'' '' B1 i have a different value

Now I wish to copy in Sheet2 in column A1 the value =Sheet!A1
'' '' '' D1 the value = Sheet!B1

I wish for such a formula to drag across. I have read other posts but in those they have wished for data to skipped rather than allocated to a different column. I have also left 2 columns intentionally blank and dragged but excel has failed to notice the pattern.

Any help would be appreciated.

Hi ,

Request you to attach the worksheet and some sample data

Thanks

As requested please find attached the relevant sample data