|
|
#1
06-24-2020, 02:55 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2016
Threaded Mode