Grouped text conversion to columns in Excel

[CPSR13]

I have report data in notepad .txt format that is grouped by employee. I need to convert to columns in an Excel spreadsheet. There are 12477 lines...is there a way to do it without having to perform text to columns, transpose, copy/paste, across the sheet for all 1000+ employees?

[#2]

@CPSR13  text to column is a best tool to convert this data you have to convert text to column according to deliminiter of tab