Extracting more than one Excel spreadsheet from a text file

Hi my friends,

I have a text file (see image) and I need to split the file based on the serial number column. at the end I want to extract this file as an excel file with more than one sheet and each sheet contain the rows for the same serial number.

Thanks in advance for your help.