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
Solved! Go to Solution.
Hi @Slawson5
Here's 3 ways:
That’s great - just what I needed. Thank you!