Extracting Data from a column to a Row

[Sheela]

Hello,
I have data arranged in a column (Sheet1), starting Column B3, the next data is in Column G3, L3, Q3, and so on (every fourth row). I have a very long row of data.
I want to be able to extract this data in Sheet2 column F, row2 and be in a consecutive order. What formula will work. Please help...
Thanks
Regards,
Sheela

 

[Xiq]

Hi Sheela,

Are the cells in between every fourth column on that row empty?

 

[Xiq]

Hi Sheela,

Please see attached.

=INDEX(Sheet1!$A$3:$W$3,,(ROWS($A$2:$A2)*5)-3)

The ROWS($A$2:$A2) is simply to result in 1 on the first row, and add 1 for each row you copy down.

The 3 is to offset the starting position.

 

[Sheela]

Thanks for your prompt help.