Hopefully this is a simple ask but I couldn't figure out how to find it on here.
I have data like this in Power Bi/Power Query:
There's repeated rows/instances for a few of the people in my data. But anytime there's a repeated row for that person, their name does not get repeated. Luckily, I can tell its the same person because of the record_id column.
My simple question is: Can I quickly have Power Bi fill in the blanks? I.e. if record_id L1 is clearly "Erin" --- becauses thats what the first row of it was, can I have it fill in the rest of the missing L1 rows with "erin"?