Transpose column data to individual rows, while repeating certain cells per row

Usually I try to sort out my excel issues on my own, but this one is tough (for me at least).

I have a google form that I am using for a job site for people to turn information over between shifts. The form returns information on one line per submission, but each submission contains multiple responses from column to column depending on which "Work Area(s)" a person selects in the form. I want to input a code that automatically converts each response (Details1, 2, etc) into their own row on a new sheet, with their respective column titles (Work Area 1, 2, etc) and their other corresponding information (like the date, discipline, and extra info) copied into these specified rows as well, while skipping over cells where the "detail" is blank. This generates an easy to read report as the end product. I'm sure there is some sort of code that can do this, it's just way beyond my knowledge of excel. Below is a simplified visual for understanding of the problem, (tried to make it all line up sorry). For the detailed out version, please see the link at the end showing a before and after.

What I start with:

Date______|Discipline___|Work Area 1___|Work Area 2___|Work Area 3____|Extra Info
10/18/17__|Disc1______|Details1_______|_____________|Details2_______|Info 1
10/18/17__|Disc2______|______________|Details3______|Details4_______|Info 2

What I want to end up with:

Date______|Discipline___|WorkArea#___|TurnDetails___|Extra Info
10/18/17__|Disc1______|Work Area 1___|Details1_____|Info 1
10/18/17__|Disc1______|Work Area 3___|Details2_____|Info 1
10/18/17__|Disc2______|Work Area 2___|Details3_____|Info 2
10/18/17__|Disc2______|Work Area 3___|Details4_____|Info 2

On the link, the tab "Form Response 1" is how the data looks when it comes out on the google form. The tab "Final Product" is how I want it to look. Hopefully I explained this well enough. Thank you for any help you are able to provide.

https://docs.google.com/spreadsheets...znA/edit#gid=0