Hi,

Lets assume your data is in columns A and B starting in A2.

Then in C2 enter the following formula and copy it down and to the right as
far as necessary:

=IF($A2=$A1,"",IF($A2=OFFSET($A2,COLUMN(A2),0),OFF SET($B2,COLUMN(A2),0),""))


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Max" wrote:

Luke,

Thanks, but it is picking up data from every other cell, so the output is
missing data. The data in column A can be many of the same number, so the
output needs to have that many columns.

ex:
CH413 4194
CH413 4895
CH413 4195
CH413 9812
CH413 9817
CH413 9593

output:

CH413 4194 4895 4195 etc

Max


"Luke M" wrote:

First column:
=INDEX(A$1:A$15,2*ROW(E1)-1)
Second column:
=INDEX(B$1:B$15,2*ROW(F1)-1)
Third Column:
=INDEX(B$1:B$15,2*ROW(G1))

Where the array references your original data, and the cell refernce at end
is whatever cell you put the formula in.

Basically, the formula looks up data, skipping every other cell.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Max" wrote:

Hi,
I have 2 columns of data that look like this

CH301 9087
CH301 9021
CH412 9594
CH412 4897

I need them to look like this

CH301 9087 9021
CH412 9594 4897

The number in column "A" can from single to multiple
There are 1,628 rows incl header

Could anybody suggest a good way to do this?

Thanks