Hello all,
Tried to search but couldn't find information close enough to what I'm looking to do.
I'm revamping a workflow I built some time ago, and I'm wanting to replace duplicate values in a column with double parenthesis, but keep all the information in the corresponding row. I'm assuming this can be accomplished with a multi-row formula, but I've made a couple sample tables below. Basically, I want to have it do double parenthesis replacement until the next unique value. Any advice is appreciated.
Sample Data Table:
| Product A | $5,000 | $8,000 |
| Product A | $2,000 | $1,000 |
| Product B | $10,000 | $500 |
| Product B | $2,000 | $1,000 |
Sample of how I am trying to make the data look:
| Product A | $5,000 | $8,000 |
| " " | $2,000 | $1,000 |
| Product B | $10,000 | $500 |
| " " | $2,000 | $1,000 |
Thanks in advance for any suggestions you may have!
