Forum Discussion
Automate transpose every 5 rows into 5 columns
Hello, I want to transpose every 5 rows into 5 columns From this : into this : Is there any way to do it in one go ? Thank you!
Let's say the data are on a worksheet named Sheet 1.
On another sheet in A1:
=LET(t, TRANSPOSE(INDEX('Sheet 1'!A:A, 5*ROW()-4):INDEX('Sheet 1'!A:A, 5*ROW())), IF(t="", "", t))
Fill down as far as needed/wanted.