hello,
I'm a novice, and this might be a bit simple for some of you excel masters. Please, someone put me out my misery!
I have a report with like 20 columns with first and last names and I'd like to merge them into one listing column
Ex.
John | Doe | Tom | Smith | Mike | Jones etc... for like 20 columns
I'd like
John Doe, Tom Smith, Mike Jones,... in one column e.g., column K
or
John Doe
Tom Smith
Mike Jones... column K
Thanx Much for the help
Bookmarks