Forum Discussion
Selecting cells for every fourth column in a single row
Hi All, Does anyone know how to get values evenly spaces across on row (so in the same row but different columns (every 4th column)) selected and copied so that they now appear below each other i...
=TRANSPOSE(FILTER(B2:SR66,MOD(COLUMN(B2:SR66)-2,4)=0,""))
where =0 determent what column you want (0,1,2,3)
But, good luck in convincing yourself that your data is right. You wont see any identification of participant or question nr
This gives the questionGroup/participant (if that's in row one). But not the question number
=TRANSPOSE(FILTER(A1:SR66,MOD(COLUMN(A1:SR66)-2,4)=0,""))