I work for a residential life department at a college.  We use a survey for our after hours staff to record calls they receive while on duty.  We have it set up to loop and merge.  They first are asked how many calls they received on the previous shift and then it loops through the questions based on that number.  When I pull that into excel it puts all of the loops on the same row.   

Currently i go through each individual row, figure our how many calls were received, and cut/paste the data into separate rows adding in the information from before the loop (the date of call, day of the week, etc.).  I am trying to figure out if there is an easier way to do this.  I think power query should be able to do this, but have not figure out how to write it.