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
Jump to PostI 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 …
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.