How to Consolidate row B based on row A?

[Sukafree]

Ive got this

1620 <tbody> </tbody>	d, <tbody> </tbody>
1620 <tbody> </tbody>	e, <tbody> </tbody>
1620 <tbody> </tbody>	f,
1621 <tbody> </tbody>	a, <tbody> </tbody>
1621	b, <tbody> </tbody>
1621	c, <tbody> </tbody>

<tbody>
</tbody>

I want it like this:

1620	d,e,f,
1621	a,b,c,

<tbody>
</tbody>

So simple but so hard

 

[radian89]

Hi,

Maybe it'll help, but you have to determine on how much the data will be.

[/URL] upload photo[/IMG]

formula, described in the picture

cheers

Adrian

 

[63falcondude]

I had a similar question. Maybe this will help you.

http://www.mrexcel.com/forum/excel-questions/940919-transpose-based-common-values.html