Help please! Rows to columns for large amount of data in excel TRANSPOSE

I have a table with thousands of rows first column represents Account number, second represents Countries they work with.   Some Accounts only have 1 country, others have 10, others have 5 etc. I wa...