Hi.
I have a spreadsheet with less than 10 columns of data of but each column having varying amount of rows with the data in each column being unique.
I need to combine data in each column from their separate rows into one cell. I have tried:
A. The clipboard copy/paste function
B: Copy into Notepad and re-paste
but thats way too much effort as there are hundreds of such data sets that I need to work on. Any help is appreciated. Thank you.
Original:
Expected results:
I have a spreadsheet with less than 10 columns of data of but each column having varying amount of rows with the data in each column being unique.
I need to combine data in each column from their separate rows into one cell. I have tried:
A. The clipboard copy/paste function
B: Copy into Notepad and re-paste
but thats way too much effort as there are hundreds of such data sets that I need to work on. Any help is appreciated. Thank you.
Original:
Expected results: