Need function that transpose the rows data of a table automatically.

		Microsoft Office Forums > Microsoft Excel > Excel
Need function that transpose the rows data of a table automatically.

07-08-2023, 04:24 AM

xor

Windows 11 Need function that transpose the rows data of a table automatically.

Office 2021

Expert

Join Date: Oct 2015

Posts: 1,103

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop Down List to Automatically Populate Data in a Table	src144	Word VBA	8	12-03-2020 04:15 PM
Transpose data form columns in rows matched with a key	Alex1s85	Excel	7	11-26-2020 01:34 AM
Transpose multiple data form rows in columns matched with a key	Alex1s85	Excel	6	06-24-2020 07:08 AM
need VBA to Transpose the Data from excel to word based on given criteria(status)	winmaxservices2	Excel Programming	1	12-19-2014 10:21 PM
Data table search function	omtinole	Excel Programming	1	07-13-2012 10:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:59 PM.