Excel 2007 : Import Multiple text rows to one row in Excel

[paulieg]

I have a text file in notepad with 4 rows for each set of data. Is there a way for me to get the data all into 1 row in the text file or all into 1 row in excel.

Thanks

P