I have 1 column of characters, they are stock ticker symbols, and each is on its own line. I need to convert this to 1 row with each ticker separated by a comma.
From something like:
mmm
axp
.
.
.
To something like:
mmm,axp,...
Is there a way to do this easily inside of Notepad ?
Thanks!!
CodePudding user response:
If you use Windows Carriage Return
You can run simply this search & replace
to have
CodePudding user response:
There’s an excellent command-line utility for dealing with CSV/tabular data, GoCSV. Its transpose command will do exactly what you want.
If you want to give it a try, it’s pre-built for Windows and can be downloaded from here.