Remove Repeat Information - TABLE View

Say I have a table view with the following output :

value1 , value2, value3

  • name1 , 2 , 4
  • name1 ,3 , 5
  • name1 ,3 , 9
  • name2 ,1, ,2

is there a way to remove duplicate values ie value1 -name1 and have the table formatted to :

  • name1 , 2 , 4
    ,3 , 5
    ,3 , 9
  • name2 ,1, ,2

Hello :wave: and welcome to the forum, @danahhmean

hmmm,

You could maybe achieve this using value mapping by regular expression. You’d have to write a regex that uses a capture group to capture every appearance of name1 after the first appearance, and then replace it with an empty string " ". But I’m not even sure that would behave as desired…