I have a large amount of data in a worksheet (67932 rows) with 26 columns (A through Z). Column A contains UPC data (12-digit numbers). Columns B-Z contain product information, a mix of text and numbers, such as which supplier, that suppliers item number, price, etc.
There are multiple duplicate rows however that have the same value in Column A, with different data in some, or all, or none, of the columns. In other words, Row 2 might look like 12UPC | SUPPLIER A | ITEM CODE A | SIZE A but Row 3 might be the same UPC and Size, but different values for supplier and item code. Some rows may contain blank cells in various columns, some might contain the same data in columns, so if I sort by Column A, I might have 2, or 3, or more rows that have matching value.
I want to be able to take all the data (Columns B-Z, and combine it all onto one row, starting with column AA and adding more columns for each additional row of data - sort of shifting the data up and to the right, basically.
I am including a sample spreadsheet, with a basic illustration of this (I've highlighted similar values, etc). Data is fake so no worries about confidential data (I just used apples, oranges, bananas etc).
Some of the other posts I came across had most of what I was looking for, but I could not get the formulas to work with MULTIPLE columns. In other words, this thread had what I wanted to do, but it only combined data from Rows and Column B, I could not figure out how to make it work on multiple columns. These are links to the 2 posts I found so far:
http://www.excelforum.com/excel-prog...o-columns.html
and
http://www.excelforum.com/excel-prog...o-columns.html
Any assistance is appreciated, I am combining a number of catalogs into one giant reference for our store and don't want to have to do this all manually.
Bookmarks