Importing blank cells form .txt

Hello,

I have to import data form .txt file that goes like this:

XXX | YYY | 111 | aaaa
| | | zzzz
| | | xccc
AAA | zzz | 222 | qqqq

After importing and using "|" as separator, my Excel 2013 seems to "ignore" blank cells, and, in this example, "zzzz" is in row 2 col 1 instead of being in row 2 col 4, "xccc" in row 3 col 1 (proper localization: row 3 col 4), and so on. Is it possible to do those things as I desired by formulas/vba script?
Thank you in advance.

Try importing it without specifying a separator, and then use the text to columns feature.

Excel 2016 (Windows) 32 bit

	A	B	C	D	E
1	Before:	After:
2
3	XXX | YYY | 111 | aaaa	XXX	YYY	111	aaaa
4	| | | zzzz				zzzz
5	| | | xccc				xccc
6	AAA | zzz | 222 | qqqq	AAA	zzz	222	qqqq

Sheet: Sheet1

Hey, thanks for reply, but I've encountered another problem. In this example (see the screen), "ssssssss" is in the line below, i.e. it should be in the same row as XXX| YYY | 111 | aaaa |. How to solve this, because method you mentioned actually works, but of course not utterly with that sort of imported text.
xxxxx.png

Provide the sample data - I can't work with a picture of it!