Deleting and combining rows in excel with con

Hello,

I hope someone knows the answer:

I have simple table

Column A: item #
Column B: text

example:

Item # Text
2 text 1
2 text 2
2 text 3
2 text 4
5 text 1
5 text 2
5 text 1
5 text 2
5 text 3
5 text 4
5 text 5

I need todo the following on the same page or another page, it doesn't matter as long as the result is the following:

Item # Text
2 text 1 text 2 text 3 text 4
5 text 1 text 2 text 3 text 4 text 5

I hope this explains it.

Thank you for your help if anyone knows how to make it happen.