If I have a list of data in a spreadsheet like this:
John 123-456-7890 email@example.com Sally 987-654-3210 firstname.lastname@example.org . . .
What would be the quickest and cleanest way to sort the data into rows and columns like
John | 123-456-7890 | email@example.com Sally | 987-654-3210 | firstname.lastname@example.org . . .
I have found the forumula
=OFFSET(Sheet1!$A$1,(ROW()-1)*#,0) that will help me get data from every # (eg 5th) row but I was wondering if there was a cleaner way