CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Sam Jefferies
Sam Jefferies

Reputation: 594

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?

Upvotes: 1

Views: 602

Answers (1)

player0
player0

Reputation: 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

Upvotes: 3

Related Questions