MERGING DATA

[PAT_CRADDOCK]

I need to merge multiple rows of First & last names into a single column of multiple rows. Is there a way to merge all of them at one time to create one column of names

[#2]

@PAT_CRADDOCK 

Can you post a screenshot of the data and of an example of the desired result?

Or make a sample workbook available via OneDrive, Google Drive, Dropbox or similar.