List all IP's found between beginning and ending targets

[Danny54]

Is there a way to list all IP's between a starting and ending range?
(Below is sheet1 which contains one row called ranges. Each range has a beginning and ending range separated by a dash. Each group is separated by a comma. There can be many groups on this line. IP ranges end at 255 then increment the value to the left and start over with that octet and continue incrementing again) below are two ranges with starting and ending values for each range

Sheet1
A
Ranges
10.90.168.0-10.90.169.255,10.103.240.2-10.103.241.250

(the ... is removed columns that would actually have data. I removed them to shorten the listing)

Sheet2 Output
A
IP's
10.90.168.0
10.90.168.1
10.90.168.2
.....
10.90.169.254
10.90.169.255
10.103.240.2
10.103.240.3
.....
10.103.241.249
10.103.241.250


Thanks

 

[Danny54]

Good Morning All
Once again I find that I need to transform similar data as in my previous request to data found below. Instead of inserting expanded ranges into new rows, I need them expanded them into one cell as shown in the new output sheet. Any help would be greatly appreciated.

Thanks

The input data changed to the following

Title	Ranges
A	10.10.10.1, 10.10.10.4-10.10.10.7
B	10.10.10.20
C
D	10.10.10.240-10.10.10.241
E	10.10.10.250, 10.10.10.251, 10.10.10.252

New Output Sheet

Title	Ranges	Expanded
A	10.10.10.1, 10.10.10.4-10.10.10.7	10.10.10.1, 10.10.10.4, 10.10.10.5, 10.10.10.6, 10.10.10.7
B	10.10.10.20	10.10.10.20
C
D	10.10.10.240-10.10.10.241	10.10.10.240, 10.10.10.241
E	10.10.10.250,10.10.10.251,10.10.10.252	10.10.10.250, 10.10.10.251, 10.10.10.252

 

[Danny54]

Good Morning Marc L

I've been trying to modify your example code to input a rearranged set. As you see I have more data per rol and the Ranges moved from Col b to Col F.
how do I adjust the array values to return all data in each row. The code that worked is in #9 above.

Thanks

Title	color	owner	tier	cir	Ranges	shift	created
A	blue	jo	1​	ab	10.1.1.0-10.1.1.5	m	22-Jan​
B
C	blue	sa	1​	ab	11.2.1.0	m	22-Jan​
D	red	sa	1​	ab	10.2.2.0-10.2.2.5,10.2.3.0-10.2.4.1	n	22-Jan​