I have data in Google Sheets that looks like
A B 1 Name: John Smith 2 Email: firstname.lastname@example.org 3 Name: Dan Jones 4 Email: email@example.com ... many rows
which I'd like to get into this format:
A B 1 Name Email 2 John Smith firstname.lastname@example.org 3 Dan Jones email@example.com ...
This is different from just a straight transpose because we're dealing with repeating sets of rows that need to be repeatedly transposed into columns.
What's the best, fastest way to do this?