I was using excel to create a series of similar lines of code based on a list of keywords, and came across this little trick that sped up the process:

basically, to convert a row in Excel into a column:

Select the data.
Right click, Copy
Right click, Paste Special, Transpose.

Thanks, Bryan, where ever you are.