Data Preparation

[Ctraore]

Hello, 

I was wondering if someone could point me to the right direction. I have a data set that item amounts for each item and then the total amount spent by the customer. The total amount is being repeated for each line item. I would like to only have it on the first item line and I have no idea where to start. Please see the attached sample document and the desired output. Your help is very much appreciated. Thank you.

[griffinwelsh · Accepted solution]

The attached sample solution should work for you.

[Ctraore]

Hi @griffinwelsh, This works. Thank you so much for your help.