Interrupted Transpose

If you don't know the answer please don't leave such annoying comments under the other's threads.

I have an answer which I will post, if and when, you comply with the Moderator's requests.

Try

Assuming data starts in row 1

in C2

=IF(AND(NOT(ISNUMBER($B2)),ISNUMBER(INDEX($B$2:$B$14,COLUMNS($C:C)+COUNTA($B$1:$B2)-1))),INDEX($A$2:$A$14,COLUMNS($C:C)+COUNTA($B$1:$B2)-1),"")

Copy across until you get a blank cell

Copy C2 down and then across at each Category change until blank cell.

If you have a MILLION rows then VBA will be a better solution, using the TRANSPOSE function.

Pleeeeeeeeaaaaaaaaaase

Thank you . . . . you are a genius but it worked just for one row. The other rows are blank.
Where can I request a VBA?

Thank you very much. That’s very kind of you. You’re so helpful. How can I ever thank you enough.

Thank you for the feedback and rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.