Move duplicate to a new column

Power Query
1

Hi there!

I would like to automatically move duplicates to a new column. How to do this in the Query Editor. I have attached a pbix, sample data, and a screenshot that explains this well.

Hope you can help, thank you!

Supervised Projects.zip (179.8 KB)

2

Hi @powerbideveloper

Here is the solution.

image
image809×476 11.1 KB

image
image759×336 9.87 KB

image
image835×744 26.5 KB

Supervised Projects.pbix (34.5 KB)

1 Like
3

Thanks so much, @Rajesh! Where can I get a lot of this coding examples using the interface you’ve used?

4

@Rajesh,

One thing I noticed is that the supervisor_id column has to be in Ascending Order for the Max to work.

Is there a way to do this same thing if there are triplicates. In other words, create a second new column with the 3rd supervisor names in that column?

5

@powerbideveloper

yes there are n number of ways to get the desired output.

image
image1440×468 35.8 KB

Supervised Projects.pbix (39.4 KB)

1 Like
6

This looks great, @Rajesh! I will try it out in the morning, nearly midnight here. Thanks so much!