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, 06:55 PM

Alansidman Alansidman is offline

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

Office 2021

עַם יִשְׂרָאֵל חַי

Join Date: Apr 2019

Location: Steamboat Springs

Posts: 121

With Power Query

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Columns",{"Attribute"})
in
    #"Removed Columns"

« 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:19 PM.