By Explaino Team · Updated
Quick answer
Welcome. In this video, I will show you how to merge two columns in Excel. So first, you can see the column one, column two, and both have datas in the column. In short: So we have another column, which is column three. Watch the 3-step walkthrough below.
Made with Explaino from one screen recording.
Welcome. In this video, I will show you how to merge two columns in Excel. So first, you can see the column one, column two, and both have datas in the column.
So we have another column, which is column three. And in column three, we will base this formula where it
is like, equals to a two and space and b two. So it will concatenate both column b and column b.
And as you can see, both datas are merged. You can just simply drag down to series up for all the columns.
Record your screen once. Explaino adds the voiceover, smart zoom and captions, and writes the step-by-step article with screenshots for you.
Free plan · no credit card required