#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
This is easy if you have Power Query.
|
#3
|
|||
|
|||
I've tried with PQ but i didn't find the way
|
#4
|
|||
|
|||
See the attached.
|
#5
|
|||
|
|||
thank you, this is great.
Please, if you have time, give me the steps for this. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
This is very helpful!!
Thank you very much! |
|
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 |