Hi,
I am working with very limited data and I am trying to delete some duplicate data in a column but without removing the row. In the case I am working on, I don't have the line item price, only the total value of the PO on each line. If I were to group or remove duplicated, I lose the other rows, but I want to keep that information for my visuals.
Here's an example of that I am trying to do
| Customer | PO | Item purchased | Total PO $ | >> | Customer | PO | Item purchased | Total PO $ |
| ABC Inc | 123456 | 123456 | $ 100.00 | | ABC Inc | 123456 | 123456 | $ 100.00 |
| ABC Inc | 123456 | 234567 | $ 100.00 | | ABC Inc | 123456 | 234567 | |
| ABC Inc | 123456 | 345678 | $ 100.00 | | ABC Inc | 123456 | 345678 | |
| ABC Inc | 456789 | 456789 | $ 333.00 | | ABC Inc | 456789 | 456789 | $ 333.00 |
| ABC Inc | 456789 | 678912 | $ 333.00 | | ABC Inc | 456789 | 678912 | |
| XYZ ltd. | 987654 | 987654 | $ 250.00 | | XYZ ltd. | 987654 | 987654 | $ 250.00 |
| XYZ ltd. | 987654 | 654321 | $ 250.00 | | XYZ ltd. | 987654 | 654321 | |
| XYZ ltd. | 321987 | 321987 | $ 1,000.00 | | XYZ ltd. | 321987 | 321987 | $ 1,000.00 |
| XYZ ltd. | 321987 | 876543 | $ 1,000.00 | | XYZ ltd. | 321987 | 876543 | |
| XYZ ltd. | 321987 | 765432 | $ 1,000.00 | | XYZ ltd. | 321987 | 765432 | |
Thank you for any help 🙂
