Combining Multiple Columns

Good Afternoon all,

I have a report that I am writing a Macro for. My issue is I have three columns of data that I need to combine into one column of data (which are names of staff). Then Remove the two empty columns. However, The end goal is to get down to one name. How or what is the best way to do this? Any thoughts.

My initial interpretation for the report was there would be data in only one of the three columns so I could write the concatenate code to combine the three lines. There would be data only in one of the three columns thus I would have one name for the cell. But then when I saw the data. There are two and sometimes three different names 1) manager, and 2 Staff members...... I need this whittled down to only one staff member.....

Maybe I can still Concatenate them and make the person running the report go in and make the decision of who stays later? Total report data lines in the report can be up to 1000 lines......

thanks for your thoughts on this and any ideas of how to whittle it down.

Lola