Extracting Lookalike Domains from Ocean: Step-by-Step Guide

Whats the best way to extract the company lookalike search from Ocean? It all dumps into a single cell. I can turn them into columns, but then i have multiple rows and multiple columns with domains in them. Is there a way to convert this into a single column of domains so that i can build a people search against the list of lookalike domains?