Transposing an array based on meeting conditions

Question

I have a set of values, narrations,and date of the transaction. the value and transaction might bee recurring. I need to list the value and narration in another sheet and recurring date in the cells next to it.

Eg:

Date        Narration   Value 
01/01/2016  Ramu        $500
02/01/2016  John        $1000
03/01/2016  Sumil       $300
04/02/2016  Ramu        $500
05/02/2016  John        $1000
06/02/2016  Sumil       $300
01/03/2016  Ramu        $500

I need the set off values to be listed in another cell in this manner

Narration      Value     Date
Ramu           $500      01/01/2016- 04/02/2016- 01/03/2016
Sumil          $300      03/01/2016- 06/02/2016
John           $1000     02/01/2016 -05/02/2016 

Answer 1

Formula method

In the example below.

In F1 I have =B2, in F2 down, I have the array formula =INDEX($B$2:$B$13,MATCH(0,COUNTIF($F$2:F2,$B$2:$B$13),0),1)

In G2:N13, I have the array formula =INDEX($A$2:$A$13,SMALL(IF($B$2:$B$13=$F2,ROW($B$2:$B$13)-1),COLUMNS($G$1:G$1)),1)

Hope this helps, you can add some error controlling like iserror to clean it up