Best Of

You are on the right track. I use form builder/viewer and here is what the main part of my ETL looks like that gets the data structured like you want.

I first filter to submitted entries by filtering to where submitted = true. This eliminates where people started filling it out, but then abandoned it.

The select columns tile reduces it down to the necessary columns that I am interested in.

In the pivot tile, start with this:

In the lower section, you will tell it what to look for an what to call it. In section 4, enter in the name of the field that you want to pivot exactly as it was entered in your form builder (including capitalization and punctuation.) For example, if you had a question in your form that said , "How many years of experience do you have?", you would need to enter that exact text in section 4. In section 3, you assign what name you want to give it as a column heading. I make 3 & 4 the same so there is no confusion as to what question it represents. Here is what some of mine look like.

This will get your data in the structure you want. You can use additional tiles like Formula or Alter Columns to change these new columns to specific data types to make it easier to build cards off of.

Hope this helps.