Forum Discussion
Combine two Excel columns without losing data
I need a way to combine two Excel columns without losing data. I would like a method which is fast and easy.
How do I copy the file down?
Copy the formula (Ctrl + c) then select the cells where the formula needs to go and Paste (Ctrl + v)
The column and row identifiers change for each cell, so this copy/paste method will not work.
- could you post a sample file please
I combined a sample Excel file with two columns of text. The difference with the real Excel file is that I have over two thousand lines of text, so a manual copy/paste will not be useful. Also, the version of Excel I am using does not have Power Query.