•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
Our take
Creating unique identifiers for repeating values in Power Query can streamline your data management process. By generating a new column that captures the first occurrence of each value in column B, you can enhance clarity and accessibility in your table. This method not only simplifies your dataset but also empowers you to maintain consistency across your data entries.
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]
Read on the original site
Open the publisher's page for the full experience
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