Hi
I have a tabel in power query excel 2016. In this query I have a tabel like this under here.
My question is, is it posible to split the A column so it will look like the second tabel under here?
In my tabel I have many other coulums to, like Amount, Restamount and som others, but this is not important in what I trying to do.
Tabel 1 Raw data in
<tbody>
</tbody>
Tabel 2 Hope to get the result like this.
<tbody>
</tbody>
Hope someone can help me out here
I have a tabel in power query excel 2016. In this query I have a tabel like this under here.
My question is, is it posible to split the A column so it will look like the second tabel under here?
In my tabel I have many other coulums to, like Amount, Restamount and som others, but this is not important in what I trying to do.
Tabel 1 Raw data in
A | ||
1 | 10018 Customer name | <-- Customer number and name |
2 | 2089 | <-- Invoice number |
3 | 10019 Customer name | <-- Customer number and name |
4 | 2000344 | <-- Invoice number |
5 | 2000345 | <-- Invoice number |
6 | 1001 Customer name | <-- Customer number and name |
7 | 345 | <-- Invoice number |
8 | 67598 | <-- Invoice number |
<tbody>
</tbody>
Tabel 2 Hope to get the result like this.
A (Customer number) | B (Customer name) | C (Invoice number) | |
1 | 10018 | Customer name | 2089 |
2 | 10019 | Customer name | 2000344 |
3 | 10019 | Customer name | 2000345 |
4 | 1001 | Customer name | 345 |
5 | 1001 | Customer name | 67598 |
<tbody>
</tbody>
Hope someone can help me out here