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.

FAQ

Thread Tools

Display Modes

07-07-2023, 03:31 PM

LearnerExcel LearnerExcel is offline

Windows 7 32bit Need function that transpose the rows data of a table automatically.

Office 2013

Advanced Beginner

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

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

Hi,

I have the excel file with a table that contains 700 rows. Now, I need that data to be copied like shown in the picture. Manually copy data by using transpose is a very lengthy process and it needs to be completed urgently.

How to resolve this problem. Please support me.

Best regards.

Attached Images

Querry.png (30.4 KB, 11 views)

« Previous Thread | Next Thread »

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 01:24 PM.