Hello all, I am trying to turn this table here and remove the duplicates, whilst preserving the relationships
User1 | Title1 | Summary1 | Code1 |
User1 | Code2 | ||
User1 | Code3 |
All of the data here is grouped together, and all I want to do is remove the duplicates of user1 such that there is only one instance of user, all while keeping the rest of the data as is. In this case, it would look like this
User1 | Title1 | Summary1 | Code1 |
Code2 | |||
Code3 |
I've been trying to use a multi row formula for this, using the expression If [Row-1:User] = "" then [User] else "" endif
But I am having trouble doing this without compromising the rest of the data
Thank You in advance
Solved! Go to Solution.
Hey @MWon,
Here is one way which works without a multirow formula:
Any questions or issues please ask :)
HTH!
Ira
@MWon Apologies I misunderstood the question my first method removes duplicates from all columns. This way here works for just the first column: