Copy row depending on value in another cell

Hello,

I have a spreadsheet that contains ticket data all on one row even if there are different categories of tickets. See example attached

What i would like to do is have 1 category per row for the same session code. So where you can see in the example J2 has the ticket code of FB005 and has multople category costs in rows K,L,M,N etc

Is there a way to duplicate the row depending on how many categories there are and transpose the prices?

Many thanks