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

'ROWS TO COLUMNS
I have a macro that may be "ready to use" for expanding rows of data to multiple rows parsing out the values in one column while duplicating all the others.

Rows to Columns - Part 1a

Run the macro on a copy of your sheet, it will prompt you to ask you to select the first column to split by...select column K. Then answer "yes" to the "titles" question. I tried it on your sheet and it duplicated the rows perfectly.