nguytravis
New Member
- Joined
- Nov 16, 2018
- Messages
- 3
Hi All,
I have two datasets which can vary in length: Employee (column A), and Funding Source (Column B)
I would like to create a table (in columns F and G) which will generate all possible combinations of Column A and Column B.
Ideally, this table would be sorted by column F, and then by Column G.
Scenario 1: 3 employees in column A and 4 funding sources in column B
<tbody>
</tbody>
Output 1: 12 lines are generated; column F shows our 3 employees 4 times while column G shows the 4 funding sources 3 times
<tbody>
</tbody>
If column A list (less header) is 4 names long and column B list (less header) is 5 names long, the output list would be 20 rows.
I have two datasets which can vary in length: Employee (column A), and Funding Source (Column B)
I would like to create a table (in columns F and G) which will generate all possible combinations of Column A and Column B.
Ideally, this table would be sorted by column F, and then by Column G.
Scenario 1: 3 employees in column A and 4 funding sources in column B
Employee List | Funding Source |
John | Grant 1 |
Kate | Grant 2 |
Alejandra | Grant 3 |
Grant 4 |
<tbody>
</tbody>
Output 1: 12 lines are generated; column F shows our 3 employees 4 times while column G shows the 4 funding sources 3 times
Employee | Funding Source |
Alejandra | Grant 1 |
Alejandra | Grant 2 |
Alejandra | Grant 3 |
Alejandra | Grant 4 |
John | Grant 1 |
John | Grant 2 |
John | Grant 3 |
John | Grant 4 |
Kate | Grant 1 |
Kate | Grant 2 |
Kate | Grant 3 |
Kate | Grant 4 |
<tbody>
</tbody>
If column A list (less header) is 4 names long and column B list (less header) is 5 names long, the output list would be 20 rows.