Formula Needed to Display the text basis on conditions

I have attached one excel sheet and want to display the name of clients in one single cell basis on below conditions of filter.Please help me with the name of formula

1.Name of Advisor

2.Current Stage

3.Stage