Forum Discussion
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...
sarah1979 Here is a guide that might help
https://www.extendoffice.com/documents/excel/3098-excel-split-every-other-row.html
you just need to adapt it to every 4th line.
thomasbk300 Thank you