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 123 E. West St Phoenix
Came over as (single column, 4 rows):
John Johnson
mailto:pretend@email.com
123 E. West St
Phoenix
How do I convert that single column into 4 columns?
3 Replies
sarah1979 If you are open to a solution using "Get&Transform Data" (a.k.a. Power Query), please see the attached file.
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
