Hi There,
I forgot what formula that I can use to merge the one data column from a unique column data
attached is the sample and the results that I want.
Kindly advice
Hi There,
I forgot what formula that I can use to merge the one data column from a unique column data
attached is the sample and the results that I want.
Kindly advice
Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks
Thanks Pepe, I 'm using office 2019
Thank you
Please update your profile accordingly, otherwise the question might be asked with each new thread/post
Thank you and just updated
Try pasting the following formula into cell C2 and dragging down: =IF(A2=A1,C1&", "&B2,B2)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks