Find & Replace + Transpose in Notepad++
one of the useful features which I learned in Notepad++ is to transpose a comma separated values to columns using Find and Replace option. This feature is going to save lot time when you have very long list. with the above example, go to replace option (CTRL+H) now enter the values as per below screenshot, Make sure to select the Extended option. when you click replace all you will get same data in a column format.