Creating a 4 column table from a one column table

I pulled data from a site that I need to format into 4 columns. When I copied and pasted it into Excel, it came over as a single column.   For example: John Johnson   mailto:pretend@email.com    1...