Deleting and combining rows in excel with con

[Solved/Closed]
Report
Posts
1
Registration date
Thursday June 30, 2011
Status
Member
Last seen
June 30, 2011
-
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
-
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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Can you data be like this too ?


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

2---------text 3
2---------text 4
5---------text 1
5---------text 2
5---------text 1
5---------text 2
5---------text 3
5---------text 5


In that case is sorting data a possibility ?
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
My question would be how many data you have and more specifically, how many different item #'s you have.

If there are not to many, Text to columns (found under the top menu Data) would be the easiest way.

Best regards,
Trowa
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
Sorry, instead of Text to columns I had in mind Transpose. Which is an option of Paste special.