Forum Discussion
Transpose data from colum to cells with number of empty cells between
Hello, I’m trying to achieve the following - Take the data from a column and transpose it across cells with predefined headings, missing a consistent number of cells each time. This is ho...
If you want all the data, enter the following formula in G2, then fill to the right:
=INDEX($A:$C,QUOTIENT(COLUMN()-7,3)+2,MOD(COLUMN()-7,3)+1)If you want only the names, with empty cells in between:
=IF(MOD(COLUMN(),3)=1,INDEX($A:$A,QUOTIENT(COLUMN()-7,3)+2),"")
Thanks for the help