merging 4 columns into 1 new column

Hello,

I have a .csv file in which I need to take data from 4 different columns and merge them into 1 new column.

I assume I need a script to do this? I am not really a programmer, so I hope there is a quick and easy way to automate this.

Any ideas?

Thanks,
Todd

Read the file in as a four column list.

In a fifth column type

= A1 & B1 & C1 & D1

into E1 and copy down. Then copy column E and edit paste special values into another column.