Transpose text in rows into two columns (Notepad++, Excel, ASAP Utilities)

[drkhateeb]

Hi all
 How can I convert a text file with this format :

Code: [Select]

Accelerated cargo
شحنة مستعجلة<br>


 Accommodation note
سند مجاملة أذني<br>


 Aggregate figures
بيانات إجمالية<br>


 All time low
هبوط بلا مقدمات<br>

convert it to TAB delimited like

Code: [Select]

Accelerated cargo شحنة مستعجلة<br>


 Accommodation note سند مجاملة أذني<br>


 Aggregate figures بيانات إجمالية<br>


 All time low هبوط بلا مقدمات<br>
in order to open it in Excl , tow columns ,TAB delimited

how to do that in EmEditor or NotePAd++

Best Regards

[spiros]

https://youtu.be/nmKVCEweyyk

ASAP Utilities for Excel - Format » Transpose column in multiple steps... - ASAP Utilities, description of our Excel tools (English)

Or in Notepad++ (with regular expressions selected)

Find: \n\n
Replace: \n
(Repeat a few times so that there are no empty rows)

And then (with regular expressions selected)

Find: ^(.*)\R(.*)
Replace: $1\t$2

Or in Emeditor or other programs
Find: ^(.*)\n(.*)
Replace: \1\t\2

[drkhateeb]

Dear spiros
Thank you very much for this great reply .