Hi can somebody please help with the following:
I have the following rows in an excel table: Row which contains Row Numbers e.g. A, B C etc and there are multiple occurrences of each, and Name which is a persons name allocated to the row. There is more than one person in a row. I currently use excel to count the number of positions in a row and create a unique list of Rows (A, B and C) which I use as headers on a separate table and a vlookup formula to populate the peoples names in their respective row. I have a sample of how this works but I don't know how to copy it here.
This is what my answer looks like and I am trying to replicate this in Power Query
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I have the following rows in an excel table: Row which contains Row Numbers e.g. A, B C etc and there are multiple occurrences of each, and Name which is a persons name allocated to the row. There is more than one person in a row. I currently use excel to count the number of positions in a row and create a unique list of Rows (A, B and C) which I use as headers on a separate table and a vlookup formula to populate the peoples names in their respective row. I have a sample of how this works but I don't know how to copy it here.
This is what my answer looks like and I am trying to replicate this in Power Query
| A | B | C |
| Jim 1 | Jack 1 | Donald 1 |
| Jim 2 | Jack 2 | Donald 2 |
| Jim 3 | Jack 3 | Donald 3 |
| Jim 4 | Jack 4 | Donald 4 |
| Jim 5 | Jack 5 | Duck 1 |
| Jim 6 | Jack 6 | Duck 2 |
| Jim 7 | Jack 7 | Duck 3 |
| Bill 1 | Jack 8 | Duck 4 |
| Bill 2 | Jack 9 | Duck 5 |
| Bill 3 | Jack 10 | |
| Bill 4 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
