How to combine multiple columns of data into one column in an Excel table

How to combine multiple columns of data into one column in an Excel table

Steps

1, open the Excel table, first make a more than one column of data.

2, then right button-copy, paste into Notepad.

3, the first column and the second column in the middle of the white space copy, click Edit-Replace.

4, replace the content is a space, replace with empty, replace all.

5, and then found all the above Notepad, and then directly copied.

6, paste into the Excel table completed.