Deleting and combining rows in excel with con

Solved/Closed
archie9999 Posts 1 Registration date Thursday June 30, 2011 Status Member Last seen June 30, 2011 - Jun 30, 2011 at 10:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 5, 2011 at 08:34 AM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Jul 2, 2011 at 09:08 AM
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 ?
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Jul 4, 2011 at 08:42 AM
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
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Jul 5, 2011 at 08:34 AM
Sorry, instead of Text to columns I had in mind Transpose. Which is an option of Paste special.
0