'Convert every 2nd & 3rd row into a column

I have a long list which of a persons name, job title and company. The problem is it's in one long list e.g.

Joe Smith
Director
Google
Sam Jones
Marketer
Facebook
Etc

Which makes it very difficult to read. Can I convert this so I end up with a table with first name, job title and company all on separate columns?



Solution 1:[1]

try:

=QUERY({QUERY(A1:A20, "skipping 3", ), 
        QUERY(A2:A21, "skipping 3", ), 
        QUERY(A3:A22, "skipping 3", )}, "where Col1 is not null")

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0