I have a table that looks like this:
| id | name | level | fromId | fromName | toId | toName |
|---|---|---|---|---|---|---|
| 1 | A | 1 | 1 | A | 3 | B |
| 2 | A | 1 | 1 | C | 4 | C |
| 3 | B | 2 | 3 | B | 6 | D |
| 4 | C | 2 | 4 | C | 7 | E |
| 5 | C | 2 | 5 | C | 8 | F |
| 6 | D | 3 | ||||
| 7 | E | 3 | ||||
| 8 | F | 3 |
I’m trying to find a way to pivot it and show the hierarchy like this:
| 1 | 2 | 3 |
|---|---|---|
| A | B | D |
| A | C | E |
| A | C | F |
But I can’t figure out how to do this with Power Query. Any idea?
No-code and low-code development platforms allow non-programmers to create apps without writing any or much code. They often consist of graphical user […]
I have an Azure key vault resource sat on a Private Endpoint that I cannot access when running my project on WSL2 […]
I have an HP Pro 3500 series MT pc and I bought an HP ENVY a couple of years ago and I […]
When ordering using paypal in magento2, it takes you to paypal, paypal already displays a confirmation, you confirm, you get redirected to […]
