Formula for grabbing a heading

[mant3220]

I apologize in advance for the uninformative title.

I am compiling a sales by customer list and the raw data is quite long (20,000 rows) so I need a single formula that can be copied all the way down. The raw data has the customer name in column A and a list of sales numbers in column B and the last row is always the total for all the sales numbers above it.

What I need is a formula in column C that will grab the customer name and a formula in column D that will equal the total. The number of rows between the customer name and the total is different for each customer.

I have made an excel that explains this problem better but cannot find a way of attaching it.

Thanks in advance for any help you can offer.

 

[dermie_72]

Your explanation is not clear, but im willing to take a stab in the dark, and guess at what you want.
C = copy column A
Paste in C
Highlight C - Data/remove duplicates
Column D1 = Sumif(A:A,C1,B:B)
Copy down

Best guess based on the information you have provided.

 

[mant3220]

How do I link an excel spreadsheet or a picture?

The problem for column C is that the customer name is always in the row containing the first transaction for that customer whereas the total value can be any number of rows down depending on the number of transactions for the customer. Putting the customer name in the same row is the difficulty.

I apologize for the unclear explanation.