Verical to Horizontal Array

I hope someone could help me.

I have a consecutive list of dates going down column A, Column B has a series of numbers which goes from 1 - 6. Column D has numbers specific to each
Example:
A B C D
01/03/2014 1 11
01/03/2014 2 16
01/03/2014 3 33
01/03/2014 4 54
01/03/2014 5 18
01/03/2014 6 19
02/03/2014 1 32
02/03/2014 2 56
02/03/2014 3 16
02/03/2014 4 13
02/03/2014 5 2
02/03/2014 6 14


and so on
Column C has some other numbers going down which are not relevant, i have left this column blank in the example above


One of the dates has 8 readings rather than 6, so i will have to account for that

I would like to put this in a horizontal array so that it looks like:


Date 1 2 3 4 5 6
01/03/2014 11 16 33 54 18 19
02/03/2014 32 56 16 13 2 14


can someone please help?

Hi,

A Pivot Table will do that for you.

Put the date column as rows, your second column as columns and your third as values.

Regards

Please see attached file for solution with formula.