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 don't know if you can do this in Excel easily, but it's trivial for a program to take your data, make these changes, and give it back to you.
You know how to export a file from Excel, in text format?
Do you know how to import a file back into Excel?
Do you know how to write SQL ?
That will be the easiest solution for your problem.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.