Transpose multiple data form rows in columns matched with a key

		Microsoft Office Forums > Microsoft Excel > Excel
Transpose multiple data form rows in columns matched with a key

FAQ

Thread Tools

Display Modes

06-24-2020, 06:53 AM

xor

Windows 10 Transpose multiple data form rows in columns matched with a key

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

Data
From Table/Range
Highligt key column
Tranform
Unpivot columns

Unpivot other columns
In column Value: uncheck blank
Select column Attribute
Remove
In column Value press 123/ABC
Change to Text
File, Close and load to
New worksheet
OK.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge	djrexy	Mail Merge	1	05-20-2020 04:04 PM
How to Loop through rows and Columns to Offset Data	Josh1012	Excel Programming	4	09-06-2018 03:20 AM
Insert rows when column A data changes then shade and autosum blanks in columns E to I	kgoosen	Excel Programming	0	08-30-2017 04:45 AM
Hide rows in multiple columns based on zero values	Deane	Excel Programming	19	06-23-2015 11:24 PM
Inserting spreadsheet data rows as form fields in a document	b3nz	Word	3	03-31-2013 07:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:15 AM.