I want to combine two streams with dissimilar data into a single final output excel sheet. I feel like this should be easy but it's eluding me. In excel I would use VSTACK to accomplish it.
| EE ID | Name |
| 1 | EE Name 1 |
| 2 | EE Name 2 |
| 3 | EE Name 3 |
| 4 | EE Name 4 |
| 5 | EE Name 5 |
| | |
| Office ID | Location |
| 1 | Location 1 |
| 2 | Location 2 |
| 3 | Location 3 |
| 4 | Location 4 |
| 5 | Location 5 |