Transpose multiple rows of data into a single row

I want to create a horizontal dataset from a vertical dataset so I can use it to create a mail merge which details outstanding invoices.

From this:

Provider Invoice No. Invoice Date Invoice Amount
1 XXXX1 01/04/2016 £1.00
1 XXXX2 02/04/2016 £2.00
2 XXXX3 03/04/2016 £3.00


To this:

Provider Invoice No. 1 Invoice Date 1 Invoice Amount 1 Invoice No. 2 Invoice Date 2 Invoice Amount 2
1 XXXX1 01/04/2016 £1.00 XXXX2 02/04/2016 £2.00
2 XXXX3 03/04/2016 £3.00

There is no upper limit to the number of outstanging invoices for a single provider although it is unlikely to be greater than 20.

I have found a macro for a 2 column dataset which I think will do what I need but I don't understand the code enough to be able to amend it and was hoping that someone could help me out :-)

Please Login or Register  to view this content.

Thanks in advance

Here's a routine by one of the masters in this forum - I didn't write it but it works on your sample:

Please Login or Register  to view this content.

Thanks for the rep! Glad it's what you needed