•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating unique identifiers for repeating values in Power Query
I have table like so:
| A | B |
|---|---|
| Number 1 | Number 1_1 |
| Number 1 | Number 1_2 |
| Number 2 | Number 2_1 |
| Number 2 | Number 2_2 |
| Number 2 | Number 2_3 |
| Number 3 | Number 3_1 |
| ... | ... |
I would like to crate new column "C" which would take the first occurrence of value in column B so that the end result would be:
| A | B | C |
|---|---|---|
| Number 1 | Number 1_1 | Number 1_1 |
| Number 1 | Number 1_2 | Number 1_1 |
| Number 2 | Number 2_2 | Number 2_2 |
| Number 2 | Number 2_3 | Number 2_2 |
| Number 2 | Number 2_1 | Number 2_2 |
| Number 3 | Number 3_1 | Number 3_1 |
| ... | ... | ... |
I know how to do that in excel with formulas, but I really want to do it in Power Query if possible?
Thanks!
[link] [comments]
Want to read more?
Check out the full article on the original site