Thread: Transpose multiple data form rows in columns matched with a key
View Single Post
 
Old 06-24-2020, 02:55 AM
Alex1s85 Alex1s85 is offline Windows 10 Office 2016
Advanced Beginner
  
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