Hi, I am trying to copy a column of cells from one sheet of my workbook to another sheet within the same workbook and turn them into mutiple columns.
Example:
Original text:
Bob
Mike
Erica
Karen
Kimberly
New Text:
Bob Mike Erica Karen Kimberly
Also, the amount of cells in the original sheet can vary. Is there a way of doing this with code?
Thanks!
Bookmarks