I have a worksheet with columns A through BR.
Column B contains customers (repeating values)
Column J contains a filing date (repeating values)
Column O contains loan information

I would like to consolidate customers and filing date into 1 row and then have the loan information in subsequent rows appended to the end.

Data looks like:

Number | Customer | ...| File Date |...| Loan Information|
1 | Customer 1 | ...| 11/30/2012|...| Loan Info 1
2 | Customer 1 | ...| 11/30/2012|...| Loan Info 2
3 | Customer 1 | ...| 05/12/2011|...| Loan Info 1
4 | Customer 1 | ...| 05/12/2011|...| Loan Info 2
5 | Customer 2 | ...| 10/31/2012|...| Loan Info 1
6 | Customer 2 | ...| 10/31/2012|...| Loan Info 2
7 | Customer 2 | ...| 10/31/2012|...| Loan Info 3
8 | Customer 3 | ...| 03/16/2010|...| Loan Info 1
9 | Customer 3 | ...| 03/16/2010|...| Loan Info 2
10 | Customer 3 | ...| 07/01/2013|...| Loan Info 1
I would like to get to:


Number | Customer | ...| File Date |...| Loan Information|...|BR|Loan Info 2| Loan Info 3| ect|
1 | Customer 1 | ...| 11/30/2012|...| Loan Info 1 |...|BR|Loan Info 2
3 | Customer 1 | ...| 05/12/2011|...| Loan Info 1 |...|BR|Loan Info 2
5 | Customer 2 | ...| 10/31/2012|...| Loan Info 1 |...|BR|Loan Info 2|Loan Info 3
8 | Customer 3 | ...| 03/16/2010|...| Loan Info 1 |...|BR|Loan Info 2
10 | Customer 3 | ...| 07/01/2013|...| Loan Info 1