Combining multiple text strings based on contents of another cell
I have a two columns which I am currently concerned with. Column A is an error number and column B is an error message. Column A has duplicates (one error number with multiple error messages).
Is it possible to output the combined column B text strings into a single cell when they share the same value in column A? Obviously this can be done manually, but with thousands of errors per week, it takes too much time.
Thank you!
Hi daunless,
Welcome to the forum.
See the attached file where I have tried creating your scenario and with the help of a pivot table, tried to combine the different error message together if they are having similar error number. Let me know if this helps you to start on. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks