How to convert or transpose variable list into table

[effluvium]

Hi there -- am struggling with converting a automated report of network switch stack members into a table. The stack size varies and could contain 1 to 6 units while the other formatting is consistent.

Example <snippet of actual output>:

ABBMcHSW01 (10.1.1.253):

--------------
dis device manuinfo
--------------
Unit 1
First mac address : 0016-e01f-0840
Product serial number: YEFF6UH1F0840
Product 3C number : 3CR17572-91
Unit 2
First mac address : 0016-e0d1-3ac0
Product serial number: YEFF75HD13AC0
Product 3C number : 3CR17572-91


ABIPBMTSW01 (10.1.1.121):

--------------
dis device manuinfo
--------------
Unit 1
First mac address : 001e-c1bf-6140
Product serial number: 9KXF9XMBF6140
Product 3C number : 3CR17172-91


ABIPCORESW01 (10.1.1.122):

--------------
dis device manuinfo
--------------
Unit 1
First mac address : 001e-c1bf-5f00
Product serial number: 9KXF9XMBF5F00
Product 3C number : 3CR17172-91


Desired Outcome:

ABBMcHSW01 (10.1.1.253): Unit 1 Product serial number: YEFF6UH1F0840
ABBMcHSW01 (10.1.1.253): Unit 2 Product serial number: YEFF75HD13AC0
ABIPBMTSW01 (10.1.1.121): Unit 1 Product serial number: 9KXF9XMBF6140
ABIPCORESW01 (10.1.1.122): Unit 1 Product serial number: 9KXF9XMBF5F00


Any suggestions on how to tackle this? Thanks!