Combining multiple spreadsheets into using Power Query AND transforming columns into rows

I am using Power Query to combine multiple spreadsheets. The data comes from Jotform so I can't change how it imports and it either brings each field across into a new column (see option 1) or it  combines all data into one cell (see option 2). I need to either transform some of the columns into rows  or split items from one cell into rows. Is that possible? See before and after:

Option 1 from Jotform

Option 2 from Jotform

What I want to achieve