Best way to not repeat values

[Gwinner]

Hi! I'm creating a spreadsheet using imported data. I started by using a pivot table unfortunately that won't work because it repeats values due to multiple entries.
To be more specific, I'm dealing with Sales Orders that are missing components to complete the order. So when I use a pivot table, for every shortage in that sales order, it repeats the sales order $ amount:

SO1 - ITEM ORDERED - ITEM1 SHORT TO COMPLETE THE ORDER - $ AMOUNT OF THE ORDER
SO1 - ITEM ORDERED - ITEM2 SHORT TO COMPLETE THE ORDER - $ AMOUNT OF THE ORDER
SO1 - ITEM ORDERED - ITEM3 SHORT TO COMPLETE THE ORDER - $ AMOUNT OF THE ORDER

What I need to do, is list the sales order number, all components short, and the $ amount of the sales order only once.

I was just hoping someone might have some advice on how to approach this.....
I'm up for any suggestions. I can also set up the data differently if that would make sense. I'm just not sure where to start.

Thank You for reading!

 

[Gwinner]

Thank you to all who viewed this post! I was able to add some data that resolved the issue.

 

[Fluff]

Good to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[Gwinner]

Hi Fluff! I apologize, I'm new and didn't even think to post what the solution for me was.....
Anyway, so i found that by breaking the Sales Order down by individual lines of each Sales Order, I was able to split the Sales Order Amount into pieces so that it would still add correctly by splitting the total amount into pieces by line.

SO1 - ITEM ORDERED - ITEM1 SHORT TO COMPLETE THE ORDER
LINE 1 - ITEM1 SHORT TO COMPLETE THE ORDER - $ AMOUNT OF LINE 1 OF THE ORDER

SO1 - ITEM ORDERED - ITEM2 SHORT TO COMPLETE THE ORDER
LINE 2 - ITEM2 SHORT TO COMPLETE THE ORDER - $ AMOUNT OF LINE 2 OF THE ORDER

SO1 - ITEM ORDERED - ITEM3 SHORT TO COMPLETE THE ORDER - $ AMOUNT OF THE ORDER
LINE 3 - ITEM3 SHORT TO COMPLETE THE ORDER - $ AMOUNT OF LINE 3 OF THE ORDER

Now it SUMS the total Sales Order by each line!
A somewhat simple solution but I was struggling for awhile before I realized I had the additional line information in the data set.

Thanks Guys!!!