combine records in multiple rows of sheet 1 to sheet 2 based on unique number in column

kindly provide excel file

BEFORE
HH Acct
1 1234
1 2345
1 3456
1 4567
2 9876
2 8765
3 1113
4 5556
4 4447
4 3335

AFTER
HH Acct1 Acct2 Acct3 Acct4 Acct5 Acct6 Acct7
1 1234 2345 3456 4567
2 9876 8765 8765
3 1113
4 5556 4447 3335

Oeldere,

This macro looks great. I am actually trying to do the exact opposite (taking a multi-column view and creating a separate row for each combination) I'm having trouble switching your code for this purpose.

Would you be able to show me how to reverse this macro?

Thanks