Notifications
Clear all
Power Query
4
Posts
2
Users
0
Reactions
133
Views
Topic starter
I'm not sure how to word this properly, but I have TABLE1 with items and TABLE2 with categories. Is there a way to append each line item in TABLE 1 with TABLE2?
TABLE1
| Item | Description |
| ITEM1 | DESCRIPTION1 |
| ITEM2 | DESCRIPTION2 |
| ITEM3 | DESCRIPTION3 |
TABLE2
| Category |
| CATEGORY1 |
| CATEGORY2 |
| CATEGORY3 |
| CATEGORY4 |
| CATEGORY5 |
Desired result
| Item | Description | Category |
| ITEM1 | DESCRIPTION1 | CATEGORY1 |
| CATEGORY2 | ||
| CATEGORY3 | ||
| CATEGORY4 | ||
| CATEGORY5 | ||
| ITEM2 | DESCRIPTION2 | CATEGORY1 |
| CATEGORY2 | ||
| CATEGORY3 | ||
| CATEGORY4 | ||
| CATEGORY5 | ||
| ITEM3 | DESCRIPTION3 | CATEGORY1 |
| CATEGORY2 | ||
| CATEGORY3 | ||
| CATEGORY4 | ||
| CATEGORY5 |
Thanks in advance!
Posted : 30/11/2023 3:39 pm
So I assume you have already connected to both Table1 and Table2. Then, in the Table1 query, you add a Custom column with the formula:
=Table2
Now expand the new column with Tables and you will get what you describe. Though 'Item' and 'Description' will be repeated on each row.
Posted : 01/12/2023 3:25 am
Topic starter
wow lol that was insanely simple... thank you so much!
Posted : 02/12/2023 12:18 pm
Glad I could help!!
Posted : 02/12/2023 1:48 pm
