Microsoft Office Forums - View Single Post - [Solved] Need function that transpose the rows data of a table automatically.

Thread: [Solved] Need function that transpose the rows data of a table automatically.

View Single Post

Old

07-08-2023, 04:24 AM

xor

xor is offline

xor uses Windows 11

Windows 11 xor uses Office 2021

xor uses Office 2021

Office 2021

Expert

Join Date: Oct 2015

Posts: 1,097

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

If your table is named Table1 then:

=INDEX(Table1,INT((ROW(1:1)-1)/4)+1,MOD((ROW(1:1)-1),4)+1)

Copy down.

Last edited by xor; 07-08-2023 at 08:42 AM.

Reply With Quote