Split and store data in comma seperated format

Hi Friends,

 

I have a simple yet unique challenge that I have, I have a sheet with two rows of IP Address and their OS written against them.

I need to separate IP addresses on the basis of OS in groups of 10 and then concatenate all the IP’s together seperated by a comma.

 

Example

 

Output Required

 

WIN

1.2.3.4, 1.2.3.6, 1.2.3.10

UNIX

1.2.3.5, 1.2.3.2, 1.2.3.1, 1.2.3.11, 1.2.3.12

just giving a sample of the table I will be working on, the count of entries would be bigger than the one given below as an example

IP Address OS 
1.2.3.4 WIN
1.2.3.5 Unix
1.2.3.6 WIN
1.2.3.2 UNIX
1.2.3.1 Unix
1.2.3.10 WIN
1.2.3.11 UNIX
1.2.3.12 UNIX

By: Aashish

Leave a Reply

Your email address will not be published. Required fields are marked *