Forum Discussion
Excel help on consolidating data.
I have a data set (15,000 rows) in excel that looks like the sample below. Is there a way get to some thing that looks like this? Basically I want to count the entries by customer, get the last date, and output in one row.
customer Number of purchases last last bought total spent
This is what the data looks like now:
customer 1 07/08/2017 $54
customer 1 08/08/2017 $58
customer 1 08/11/2017 $37
customer 1 08/15/2017 $23
customer 1 08/20/2017 $78
customer 1 08/23/2017 $76
customer 1 08/27/2017 $54
customer 1 09/08/2017 $54
customer 2 07/08/2017 $54
customer 2 08/08/2017 $58
customer 2 08/11/2017 $37
customer 2 08/15/2017 $23
customer 2 08/20/2017 $78
customer 2 08/23/2017 $76
customer 2 08/27/2017 $54
customer 2 09/08/2017 $54
customer 3 07/08/2017 $54
customer 3 08/08/2017 $58
customer 3 08/11/2017 $37
customer 3 08/15/2017 $23
customer 3 08/20/2017 $78
customer 3 08/23/2017 $76
customer 3 08/27/2017 $54
customer 3 09/08/2017 $54
Hi Michael,
You may use Pivot Table to summarize your data
