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:
Use Text import wizard (menu Data > From Text) to import values into cells.
Select imported cells (as rectangular selection) and use Copy.
Use Paste Special with Transpose option to flip rows and columns (this is what you requested).
Paste the result back to text file.