Organize multiple columns into one column

  • Thread starter Thread starter Tajeri
  • Start date Start date
T

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to columns 2
Merging multiple columns into one column (dynamically) 1
Pivot Table - Easy way to add multiple Columns into Data section? 6
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Text to columns. Only the first column appears in the wizard. 4
Excel Help to copy information from one row at a time to another sheet 1
Append multiple columns 2
append multiple columns 2

Back
Top