I have come across a problem that I have not been able to solve yet despite trying different ways for the last 2 days.
I am looking to merge 2 or more row data for each Employee in the list where the rows to be merged are selected with CheckBoxes.
I have added an example Workbook with dataset I have and the objective I wish to achieve. The approach I explored conforms looping within looping and I am going nowhere. Would someone be kind enough to guide me (or give an example) on how I can achieve the results shown in my example Workbook please?
ProblemAndObjective.JPG
Bookmarks