Forum Discussion
Solved
Combining Tables with No Matching Column
Hello,
I have two data tables coming from seperate sources, and I need to combine them both. The rows in the subcategory table are a subset of the category table and I'm trying to combine them so we have one for each subcategory for every category. Since there are no matching columns, I'm not sure how to merge the tables.
Category Table:
| Category |
| A |
| B |
| C |
Subcategory Table:
| Subcategory |
| ABC |
| DEF |
| GHI |
| JKL |
| MNO |
| PQR |
| STU |
Combined Table:
| Category | Subcategory |
| A | ABC |
| A | DEF |
| A | GHI |
| A | JKL |
| A | MNO |
| A | PQR |
| A | STU |
| B | ABC |
| B | DEF |
| B | GHI |
| B | JKL |
| B | MNO |
| B | PQR |
| B | STU |
| C | ABC |
| C | DEF |
| C | GHI |
| C | JKL |
| C | MNO |
| C | PQR |
| C | STU |
How could I go about combining the tables? I'd really appreciate any help!
Thank you!
2 Replies
Thank you!
