Join duplicate names in a single row

0

I have this worksheet:

IhaveinthespreadsheettheclientELISMARCARLOSRODRIGUESDAMATA,whomade3purchases,twoon10/08/2014andoneon20/08/2014.WhatIneedistoconsolidateallpaymentsonthesamedateonthesameline,ie,looklikethis:

The two installments on August 10, 2014 were added together (399 + 1561.56) and consolidated on a single line, and the one on 08/20/2014 remained normal, since it was another day.

I tried with dynamic spreadsheets, the best result I had was this:

It separates payments by DATA and groups the installments that have been paid by CPF. What already helps, though, is that I need the worksheet to be in the above pattern, to use in a code that is already ready.

    
asked by anonymous 20.11.2014 / 13:12

1 answer

2

As gmsantos commented, you can put it in PivotTable, to make it easier:

  • Selects the entire table, including headers;
  • Formatted as table, check "My table has headers";
  • Inserts a PivotTable and in the data selects the table that you
    just created;
  • To wrap the table, drag CLIENT NAME on the rows, and REAL VALUE
    OF PLOTS in values;

It will display the sum for each client.

    
20.11.2014 / 13:58