Multiple Linkage Data Consolidation

I am attempting to consolidate multiple RowIDs that are all interlinked with each other. They all share at least one (or more) RowID in the List column which would require all RowIDs within that record to be consolidated.

This is one example of my starting data but have several different combinations that would be made, and the overall data size is very dynamic and unpredictable.

All of the rows share a common list number and therefore all list numbers on that row should be included into the consolidation until it is down into one single row.

In the example above this is what the ending should appear to be:

Through my several attempts with Recursive Loop and methods to consolidate the data I have not been successful. The data is currently grouped by RowID as a set.

Any help in developing a workflow to achieve this outcome would be greatly appreciated.