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

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.

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.