Home > Software design >  Converting a column to row CSV in Notepad
Converting a column to row CSV in Notepad

Time:12-28

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

enter image description here

You can run simply this search & replace

enter image description here

to have

enter image description here

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.

  • Related