Merge Duplicate Rows and Combine Unique Data

I am trying to consolidate duplicate rows based on Column A, where all information in additional columns (up to 10) consolidates as well REGARDLESS if there is info in the cell. I have this attached sheet with what I am looking for except this one removes all duplicate rows based on Col A AND requires one complete row of data (this being my issue). I am going to have over 1000 rows of data to consolidate with many different inputs in Col A. Rickt33(1).xlsm

Originally posted: http://www.ozgrid.com/forum/showthread.php?t=193557