Forum Discussion
User537843
Jan 13, 2022Copper Contributor
How to transpose and skip?
Hello everyone, thanks for being so helpful. I have columns where I need to transpose them into rows. I need to copy only every 6th column in the source, but not skip cells in the row destinat...
OliverScheurich
Jan 13, 2022Gold Contributor
=INDEX($A$1:$AB$1,ROW($A$1)+(ROW(A1)-1)*6)
Maybe with this formula as shown in the attached file.