How to convert several rows to columns in notepad++

notepad

Let's say I have this in Notepad++:

CHARGE_ID   LAST_MODIFIED   CHARGE  PROPORTION  CURRENCY_ID ACCOUNT_ID
2194703831  28-06-2016 11:44:02 2.49    1   95000060    590511

I would like to convert it like that:

CHARGE_ID: 2194703831
LAST_MODIFIED: 28-06-2016 11:44:02
CHARGE: 2.49
PROPORTION: 1
CURRENCY_ID: 95000060
ACCOUNT_ID: 590511

Best Answer

You need to choose right tool for the job. Use Excel to help you with your text file. Inside the Excel:

  1. Use Text import wizard (menu Data > From Text) to import values into cells.

  2. Select imported cells (as rectangular selection) and use Copy.

  3. Use Paste Special with Transpose option to flip rows and columns (this is what you requested).

  4. Paste the result back to text file.

Related Question