Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
185
Views
Topic starter
I suspect that I need to be using a many to many join for this one but I'm not quite sure how to get my head around it. I start with a list that looks like this.. I am also attaching a file with an example.
BuildingDevicePorts
| AB1 | Widget | 3 |
| AB2 | Widget | 10 |
I want to end up with..basically a new table that has inserted a new row for the number of ports and then numbered it.
| Building | Device | Ports |
| AB1 | Widget | 1 |
| AB1 | Widget | 2 |
| AB1 | Widget | 3 |
| AB2 | Widget | 1 |
| AB2 | Widget | 2 |
| AB2 | Widget | 3 |
| AB2 | Widget | 4 |
| AB2 | Widget | 5 |
| AB2 | Widget | 6 |
| AB2 | Widget | 7 |
| AB2 | Widget | 8 |
| AB2 | Widget | 9 |
| AB2 | Widget | 10 |
Posted : 11/06/2021 6:52 am
Hi Anne,
Add a new column with the formula:
=Text.Repeat("z",[Ports])
then split this new column into rows by number of chars (1).
Posted : 11/06/2021 11:27 pm
