Read from text file, change formatting, write to excel

I have a text file that reads as:

SAAS_1

IP: xxx.xxx.xxx.xxx
Port id: xxxx.xxxx.xxxx
Serial number: xxxxxxxxxxxxx
Model: xxxxx
SAAS_2

I want to break the data up into seperate colums in excel as:

SAAS_1 SAAS_1 SAAS_1 SAAS_1
IP:  Port id: Serial number: Model:     
SAAS_2 SAAS_2 SAAS_2 SAAS_2

One issue we're having is not all serial numbers are coming back with an IP. 

Is there a powershell script that can do this automatically?