0

Have a table in column a i have a list of part numbers p101, p101, p102, p102, p102, p103, p104 etc

part no alternative
p101 a178
p101 a196
p101 a192
p102 a135
p103 a165
p103 a145
p104 a179

i need to have it like this but i cant work out the equation, anyone help

part no alternative
p101 a178 a196 a192
p102 a135
p103 a165 a145
p104 a179

3
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by JhonMoney
0

Just a repeat of the answer I gave to your post in the database section:

I would export this data, in text format, to a file. Then write a short program to make these changes. Then import the data back into Excel.

0

Have a table in column a i have a list of part numbers p101, p101, p102, p102, p102, p103, p104 etc

part no alternative
p101 a178
p101 a196
p101 a192
p102 a135
p103 a165
p103 a145
p104 a179

i need to have it like this but i cant work out the equation, anyone help

part no alternative
p101 a178 a196 a192
p102 a135
p103 a165 a145
p104 a179

I see your question. In my opinon you should text format for that problem.
For this slelect your data and go to Home tab Number group and select TEXT.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.