Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-24-2020, 02:55 AM
Alex1s85 Alex1s85 is offline Transpose multiple data form rows in columns matched with a key Windows 10 Transpose multiple data form rows in columns matched with a key Office 2016
Advanced Beginner
Transpose multiple data form rows in columns matched with a key
 
Join Date: Oct 2019
Location: Thessaloniki, Greece
Posts: 30
Alex1s85 is on a distinguished road
Default Transpose multiple data form rows in columns matched with a key

Hello to everyone,




I have a table with 80.000 records(rows) with data in 15 columns.
In the first column i have the customer id and in the other columns their invoices numbers(one customer has one invoice and another 14)


I want to transpose the invoices numbers and match them with the customer i.


For example:


Customer A Inv1 Inv2 ... Inv14


to




Customer A Inv1


Customer A Inv2


Customer A ...


Customer A Inv14







Could you please help me??


Pls find the data in the attached .xls


Attached Files
File Type: xlsx how to transpose.xlsx (24.1 KB, 9 views)
Reply With Quote
  #2  
Old 06-24-2020, 04:26 AM
xor xor is offline Transpose multiple data form rows in columns matched with a key Windows 10 Transpose multiple data form rows in columns matched with a key Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

This is easy if you have Power Query.
Reply With Quote
  #3  
Old 06-24-2020, 04:34 AM
Alex1s85 Alex1s85 is offline Transpose multiple data form rows in columns matched with a key Windows 10 Transpose multiple data form rows in columns matched with a key Office 2016
Advanced Beginner
Transpose multiple data form rows in columns matched with a key
 
Join Date: Oct 2019
Location: Thessaloniki, Greece
Posts: 30
Alex1s85 is on a distinguished road
Default

I've tried with PQ but i didn't find the way
Reply With Quote
  #4  
Old 06-24-2020, 04:45 AM
xor xor is offline Transpose multiple data form rows in columns matched with a key Windows 10 Transpose multiple data form rows in columns matched with a key Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

See the attached.
Attached Files
File Type: xlsx how to transpose_2.xlsx (30.4 KB, 9 views)
Reply With Quote
  #5  
Old 06-24-2020, 04:53 AM
Alex1s85 Alex1s85 is offline Transpose multiple data form rows in columns matched with a key Windows 10 Transpose multiple data form rows in columns matched with a key Office 2016
Advanced Beginner
Transpose multiple data form rows in columns matched with a key
 
Join Date: Oct 2019
Location: Thessaloniki, Greece
Posts: 30
Alex1s85 is on a distinguished road
Default

thank you, this is great.
Please, if you have time, give me the steps for this.
Reply With Quote
  #6  
Old 06-24-2020, 06:53 AM
xor xor is offline Transpose multiple data form rows in columns matched with a key Windows 10 Transpose multiple data form rows in columns matched with a key Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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.
Reply With Quote
  #7  
Old 06-24-2020, 07:08 AM
Alex1s85 Alex1s85 is offline Transpose multiple data form rows in columns matched with a key Windows 10 Transpose multiple data form rows in columns matched with a key Office 2016
Advanced Beginner
Transpose multiple data form rows in columns matched with a key
 
Join Date: Oct 2019
Location: Thessaloniki, Greece
Posts: 30
Alex1s85 is on a distinguished road
Default

This is very helpful!!
Thank you very much!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose multiple data form rows in columns matched with a key 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
Transpose multiple data form rows in columns matched with a key 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 10:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft