The worksheet contains column A that lists a name (A2) and under that name, 11 cells containing labels. Column B lists corresponding data on the same row, for each label in A.
In the original worksheet, this is repeated a few hundred times.
In the example, the 11 cells have been manually transposed to the same row as the "Name" label, starting from Column E, and extending to Column O.
And the data from column B has been manually transposed across these columns, on to the same row as the name.
Required: a script or formula to do this for several hundred entries.