I have customer last name in column A, first name in column b. But then I have all the accounts numbers associated with each name going horizontally across all the way to some column BG. How can bring the account numbers under each associated name?

Example

Smith John  12344 12355 12556 12666 12777

Doe    Jane.  12345 12345 12345

What I want –

Smith John 

12344

12355

12556

12666

12777

Doe Jane

12345

12345

12345

​I have customer last name in column A, first name in column b. But then I have all the accounts numbers associated with each name going horizontally across all the way to some column BG. How can bring the account numbers under each associated name? ExampleSmith John  12344 12355 12556 12666 12777Doe    Jane.  12345 12345 12345 What I want -Smith John 1234412355125561266612777Doe Jane123451234512345     Read More

​