Apr 12 2020 05:18 AM - edited Apr 12 2020 05:21 AM
Hi everyone,
Need some help here. I have been stumped on trying to copy all the cells with content from one column, and pasting them onto another column which has space to accommodate. The attached image will show what I'm trying to do.
Please see this link: https://prnt.sc/rxsc9n
It illustrates what i am trying to do. My list spans about 60,000 rows, so copying it manually is out of the question. :)
Thank you so much, Excel gurus!
Apr 12 2020 06:08 AM
SolutionBetter if you attach screenshot directly to your post, not everyone will click on the link of unknown source. Even more better to attache simple sample file - from ones who check the screenshot not everyone will repeat it in Excel to illustrate the formula.
You may combine columns into third one with IF() formula applying the logic
if first column cell is empty
then second column cell value
else first column cell value
Enter it for first row, after that select third column till end of the range and Ctrl+D.
Apr 12 2020 07:03 AM
Feb 07 2021 11:15 AM
My apologies, but I still don't understand how to do this, your help is most appreciated. I am trying to merge two columns, one has first, the second has last name.
N
Feb 07 2021 12:38 PM - edited Feb 07 2021 12:39 PM
You wrote to @Sergei Baklan
My apologies, but I still don't understand how to do this, your help is most appreciated. I am trying to merge two columns, one has first, the second has last name.
My first response to you is that you are asking a totally different question from the one that's first in this thread, and for that you should really start a new thread.
Next, to answer your question: to combine first name with last name, assuming first is in column A and second is in column B you could use either of the following, and then copy down to all succeeding rows as needed:
=CONCATENATE(A1," ",B1) which will yield "John Smith"
or
=A1&" "&B1 with the same result
If you want the new column to be Last, First (so as to be able to sort alphabetically by last name)
=CONCATENATE(B1,", ",A1) or
=B1&"' "&A1
But for future reference, please start a new thread ESPECIALLY when you're responding to something that is nearly a year old.
Apr 12 2020 06:08 AM
SolutionBetter if you attach screenshot directly to your post, not everyone will click on the link of unknown source. Even more better to attache simple sample file - from ones who check the screenshot not everyone will repeat it in Excel to illustrate the formula.
You may combine columns into third one with IF() formula applying the logic
if first column cell is empty
then second column cell value
else first column cell value
Enter it for first row, after that select third column till end of the range and Ctrl+D.