Forum Discussion
How to remove duplicate data without deleting the row?
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 :)
2 Replies
can you eloborate a little bit in detail way?
What is your data source? Is it Excel?
