combining columns
Hello my learned friends in the excel forum. I am looking for a way to take 2 columns and combine them into one coumn, sort of the opposite of the text to columns function. In my attached example, I start with a sample 3 row spreadsheet with 2 columns. The first column is the filename, and the second column is the file extension. I want to use a formula or something to change these 3 rows and 2 columns to just 3 rows and one column, as illustrated in the second excel attachment. Is there a way to do this? Many thanks
|