ShawnMichael
05-17-2014, 03:40 AM
Hi All !
P.S I posted the same question on mrexcel.com but no one answered for 2 weeks, so I am posting here.
I have two columns in Sheet 1, Column A contains employee names (from cell A2:A250). And Column B contains 3 account names (from B2:B4).
Employee Names
Accounts
John Smith
Salaries & Wages
Mike Little
House Rent Allowance
Bill Jellen
Transport Allowance
Sean Paul
I want to create a list in Column C, which will do this:
Results
Salaries & Wages
John Smith
Salaries & Wages
Mike Little
Salaries & Wages
Bill Jellen
Salaries & Wages
Sean Paul
House Rent Allowance
John Smith
House Rent Allowance
Mike Little
House Rent Allowance
Bill Jellen
House Rent Allowance
Sean Paul
.....
So all the accounts in column B will be stacked on the names in Column A, with each name one by one, as in the above table.
I would be thankful for your help.
Regards
P.S I posted the same question on mrexcel.com but no one answered for 2 weeks, so I am posting here.
I have two columns in Sheet 1, Column A contains employee names (from cell A2:A250). And Column B contains 3 account names (from B2:B4).
Employee Names
Accounts
John Smith
Salaries & Wages
Mike Little
House Rent Allowance
Bill Jellen
Transport Allowance
Sean Paul
I want to create a list in Column C, which will do this:
Results
Salaries & Wages
John Smith
Salaries & Wages
Mike Little
Salaries & Wages
Bill Jellen
Salaries & Wages
Sean Paul
House Rent Allowance
John Smith
House Rent Allowance
Mike Little
House Rent Allowance
Bill Jellen
House Rent Allowance
Sean Paul
.....
So all the accounts in column B will be stacked on the names in Column A, with each name one by one, as in the above table.
I would be thankful for your help.
Regards