Hi guys, I know there's some clever database people around here...this is killin' me.

I've written all my meta titles, meta descriptions and page/body descriptions in an HTML editor (not tables, just formatting tags like <strong>, <br>, etc)...
I'm trying to get this information into an Excel spreadsheet so I can upload through EasyPopulateAdvanced.

My data is written vertically (as a human might do), so I'm having trouble getting it to import properly.
I need vertical text to import horizontally (as required by EasyPopulateAdvanced).

By "vertical" I mean, each 'section' of my data is written downwards:

<meta title>
<meta description>
<product title>
<page description>


It's NOT written "horizontally":

<meta title><meta description><product title><page description>


EPA requires each of these sections to be contained in one row, with each section in it's own column (one product per row)...
but since I don't write all my data in ONE LINE, I'm having trouble getting it imported properly.

I really don't want to edit my data so it's all on one line...that makes it impossible to edit later.
Not to mention it's completely against intelligent human nature!!

I'm sure I'm not the first person to run into this problem,
but I can't seem to discover a method that works properly.

I really don't want to copy/paste 3000 lines manually...again.
So does anyone have any secret (powerful) apps that import text into Excel?

It would be great if Excel's import wizard gave more control over the parsing...
I need to take vertical text blocks and place them horizontally.

I'm sure I've lost everyone by this point...