Organize multiple columns into one column

[Tajeri]

I was wondering if there is an easy way to take multiple
columns of data and move them into one column (other than
copy and paste). I used the 'text to columns' tool, which
separated the data into various columns using the comma
delimiter. Ultimately, I want to summarize all of the
data using a Pivot Table report, and using the list
approach has been the only way I know to do this (only way
to ensure all data is referenced).

Any help would greatly be appreciated.

Regards,
Tajeri

 

[BrianB]

Not sure why you would want to put several columns into 1 but :-

1. Copy a formula down an empty column like =A1 &"," &B1 .. which put
a comma between the cell values. Could use a space etc.

2. Save the file as .csv (which will put the commas back and make
text file). Rename the file with a .txt suffix. Open the file with th
"Fixed width" option, which puts it all into column A