Hi Gurus,
I have a survey responses downloaded in excel with having 6 columns entries along with username in column A, there 6 columns with certification and completion year against user. i want all the certification completed by the user in one column after that next user. Attached the sample file for your reference. Thanks in advance. Highly appreciated. either formula or macro is accepted.
pic1.png
expected output should be
pic2.png
Bookmarks