Excel-Fu: Column to comma separated
Bla bla bla nmap so on and so forth..
So here you are...a port scan result list. One column of data, and there's nothing between you plugging this info into your vuln scanner besides the fact that your vuln scanner needs a comma separated list.
If Laziness prevails, skip the script writing and turn to Excel.
if Column A contains your ports(or anything else you want to craft into a list separated by commas..or whatever)...
Insert this function into cell B1 =A1
Insert this function into cell B2
=B1&","&A2
And then drag the formula in B2 down to fill the rest of the B columns until there is no more data to match in column A.
The value in the last nonblank cell in column B will be your separated one line list.
Credit:Superuser.com: http://superuser.com/questions/240858/convert-a-column-into-a-comma-separated-list