Hi All,
Attached file has two tabs (Raw Data & OutCome). What I am trying to achieve is transposing column F & G of the Raw Data onto OutCome tab. The catch is to transpose basis the role which is listed as heading of Outcome tab.
If in the list we have more than open person with similar role, we can concatenate the names as done in cell L3 of OutCome tab.
If there is no name for any role in the data we need to put a "-" in OutCome tab.
Request your help to solve this with VBA. Thanks in advance for your help and efforts.
Attached file has two tabs (Raw Data & OutCome). What I am trying to achieve is transposing column F & G of the Raw Data onto OutCome tab. The catch is to transpose basis the role which is listed as heading of Outcome tab.
If in the list we have more than open person with similar role, we can concatenate the names as done in cell L3 of OutCome tab.
If there is no name for any role in the data we need to put a "-" in OutCome tab.
Request your help to solve this with VBA. Thanks in advance for your help and efforts.