Combining multiple rows into one row

I would like to consolidate multiple rows into one row. An example is attached, with beginning and ending versions on each tab.

I need to move each of the "New Task" columns (N-U) to one line based on each "house" number (column B). The final version lists the "New Task" numbers out to the far side, as there could be many numbers and it could extend out very far.