Transpose multiple data form rows in columns matched with a key

		Microsoft Office Forums > Microsoft Excel > Excel
Transpose multiple data form rows in columns matched with a key

FAQ

Thread Tools

Display Modes

06-24-2020, 02:55 AM

Alex1s85

Windows 10 Transpose multiple data form rows in columns matched with a key

Office 2016

Advanced Beginner

Join Date: Oct 2019

Location: Thessaloniki, Greece

Posts: 30

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

how to transpose.xlsx (24.1 KB, 11 views)

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