Finding Duplicates, Transposing Data From Dupe Rows

[indi visual]

I have an example worksheet attached.


This should make my question relatively simple.


http://www.iandmyself.me/example.wksht.transpose.consolidate.duplicates.xlsx


I have duplicate company names down a column that contain data that needs to be on one consolidated row.


I'm hoping someone could help me with a code that will gather the data from the duplicate rows (from the TRADE NAMES column and the REG #'s column), and


transpose-consolidate that data across one single row for that particular company name (deleting the duplicate company name rows while it's executing


would be awesome).


Please please help, sincerly Indi.

 

[Luke M]

Indi,

Here's the steps your code could take...

1. Sort Data by a column that contain blanks (hereafter called BlankCol)

2. Sort Data then by TRADE NAMES, then by REG #'s

3. Select BlankCol. Ctrl+G, Special, blank cells only

4. Type "=", then hit up arrow

5. Hit Ctrl+Enter to fill all cells.

Repeat 1-5 as needed for other columns with blanks.

6. All blanks are now filled in, remove duplicate rows (many ways to do this, fastest is to use a COUNTIF or something. I'm sure you can find another thread if you need help)


Essentially, this process keeps filling in all the blank/unknown cells with data from the "known". Then you'll end up with complete rows of data.