When multiple values exist within a cell, copy rest of cells into row(s)

Sorry for the confusing title.

I am looking to create terraform configuration files based on CSVs we receive with the relevant information.

For the most part 1 row = 1 config, and each cell in a row has one piece of information. but occasionally there is a cellthat has multiple values in it. Either in the form of ports separated by commas, like this:

7000, 7001, 7002, 7003

Or in the form of IP addresses, seperated by newlines, like this:

10.0.0.1/32

10.0.0.2/32

10.0.0.3/32

10.0.0.4/32

Is it possible with a programmatically or otherwise to go through the excel sheet, and whenever one of these scenarios is encountered, the whole row is copied to a new row with the rest of the cells in that row remaining the same, but with an individual port or IP address per row.

Fun twist = some rows, will contain two or more cells with multiple values in them, so any solution would need to move procedurally through the sheet.

Thanks!

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

Here is a proposal that employs Get & Transform (Power Query).
1. Convert the "Before" data into an Excel table (Ctrl + t)
2. In Power Query replace the default code with:

Please Login or Register  to view this content.

Note that I named the "Before" table tblBefore whereas Excel will likely automatically name it Table1, so either change the name to tblBefore prior to loading it into Power Query or the name in the Source line of code from tblBefore to Table1.
Let us know if you have any questions.