Transpose data from colum to cells with number of empty cells between

Occasional Contributor



I’m trying to achieve the following -


Take the data from a column and transpose it across cells with predefined headings, missing a consistent number of cells each time.


This is how the data starts 



This is what i'm trying to achieve 



I've researched transposing and indexing but can't find a solution to what i'm trying to achieve.

Many thanks for any help



2 Replies


If you want all the data, enter the following formula in G2, then fill to the right:


If you want only the names, with empty cells in between: