Forum Discussion

ATMC's avatar
ATMC
Regular Visitor
3 years ago

Duplicate Text String in Column

I have merged 2 tables based on a unique ID #, in one of the tables there is multiple rows of values (text) based on the same ID#, when the merge was done new rows where added based on the multiple v...
Need Help
ATMC's avatar
ATMC
Regular Visitor
3 years ago

 

Hard to give you an example from the actual table but from the screenshot, Need to keep the text in the first row of the Blue box, remove the duplicates but keep the three rows adjacent in the orange box

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ATMC ,

 

You can do as follows.

Sample data.

 

1.Select [Risk Register] column to group by. In the operation select "All Rows".

2.Add a custom column to add an index column.

3.Expand the Custom column and add a conditional column.

4.Remove the unneeded columns and rename the conditional column as "Risk Regiter".

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • ATMC's avatar
    ATMC
    Regular Visitor
    3 years ago

    Hi,

    Thanks for your help on this, unfortunately your solution did not return the results I was after, Thanks again,

    Best Regards