I have the top 40 music charts in a text file

the file is like this

5 rows consisting of

line 1 name of artist
line 2 song
line 3 date
line 4 chart position
line 5 is blank

i need to be able to import the list into excel
like this into 4 columns

name of artist, song, date, chart

Any ideas?


Tia