Keep the value only of first row per each unique name

[Slawson5]

Hello,

I would like to duplicate the first value down per each unique name. 

This is my current data - 

Name	Category
Sarah	Live
Sarah	Not Live
Sarah
Sarah

Then I would like the output to be -

Name	Category
Sarah	Live
Sarah	Live
Sarah	Live
Sarah	Live

I'm trying multi row formula but can't quite get there (I'm new to this!) so would appreciate the help!

Thanks

Sarah

[Luke_C · Accepted solution]

Hi @Slawson5 

Here's 3 ways:

1. Multi-row: Use an if statement to check if the name is equal to the previous row's name
2. Sample: Take the first row for each Name, then join back to the dataset
3. Summarize: Take the first row for each Name, then join back to the dataset

[Slawson5]

That’s great - just what I needed. Thank you!