•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
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#Power Query
#unique identifiers
#repeating values
#first occurrence
#column C
#new column
#table
#Number
#value in column B
#formula
#Excel
#end result
#data transformation