|
|
#1
11-24-2020, 01:02 AM
|
|||
|
|||
Transpose data form columns in rows matched with a key
Hello to every one,
I have a table with thousands of records(rows) with data in 3 columns. In the first column I have the customer id and in the other columns their invoices numbers and the date (may the customer id appears more than one times). I want to transpose the invoice numbers and match them with the customer id horizontally. For example, I want to have a transformation as in the picture. I 've tried with PQ but w/o successful results. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Merging all data between two sheets into a third one without duplicates or rows or columns | Ricko_uk | Excel | 4 | 08-27-2020 01:16 AM |
| Transpose multiple data form rows in columns matched with a key | Alex1s85 | Excel | 6 | 06-24-2020 07:08 AM |
 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 |
Windows 10 
Office 2016
Threaded Mode