Loop through then keep only value first row when unique id match

[rockeylearning]

Hi Everyone!

I need some help on how to accomplish this. How do I loop through the able and update the ID column with the value "header" if Line 1 matching. Basically, only keep the value "Header" on the first row and remove the rest when Line 1 is the same.

This is the sample 

ID	Line 1	Amount	Line 3
Header	ABC123	33.33	Some description
Header	ABC123	11.11	Some description
Header	ABC123	11.11	Some description
Header	ABC123	11.11	Some description
Header	EDF456	45.36	Some description1

Output

ID	Line 1	Amount	Line 3
Header	ABC123	33.33	Some description
	ABC123	11.11	Some description
	ABC123	11.11	Some description
	ABC123	11.11	Some description
Header	EDF456	45.36	Some description1

[JosephSerpis]

Hi @rockeylearning one way to do this is to use a Multi-Row tool to rank your data then use a formula tool to blank any data that is not Rank 1. I mocked up an approach showcasing this.

[binuacs · Accepted solution]

@rockeylearning One way of doing this

[rockeylearning]

@binuacs thank you so much. This works perfectly!

[rockeylearning]

@JosephSerpis thank you! this solution works as well.