Hi all,
I have two tables, one with periods and one with resources and I'd like to combine them into one (so each resource gets a row for each period).
Example:
Table 1:
<tbody>
</tbody>
Table 2:
<tbody>
</tbody>
Desired table:
<tbody>
</tbody>
Any suggestions on how to do this (using VBA or formula's)?
I have two tables, one with periods and one with resources and I'd like to combine them into one (so each resource gets a row for each period).
Example:
Table 1:
Resource | Type |
James | Full Time |
William | Part Time |
Nick | Part Time |
<tbody>
</tbody>
Table 2:
Period | Start Date |
2015-01 | 1/1/2015 |
2015-02 | 2/1/2015 |
2015-03 | 3/1/2015 |
<tbody>
</tbody>
Desired table:
Resource | Period |
James | 2015-01 |
James | 2015-02 |
James | 2015-03 |
Wiliam | 2015-01 |
William | 2015-02 |
William | 2015-03 |
Nick | 2015-01 |
Nick | 2015-02 |
Nick | 2015-03 |
<tbody>
</tbody>
Any suggestions on how to do this (using VBA or formula's)?