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 a179i 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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.