Grouping multiple columns by custom names

Hi all, Really struggling to put my mind to where this solution might be. Wondering if anyone can lend a hand?

I have form data getting collected into a Sharepoint list. Each row on that list is seperated by an unique employee ID.

for each row, we have about 15 columns, each holding a score of 1 through 4 depending on what the user selected when they filled out the form. 

However, the form is seperated into sections, each section having about 5 answers in each. For example:

You can see here that the section is titled Personal Efficacy, and under that there are multiple questions: 

Now once the form is submitted, the data comes through on a single like as follows (Hopefully you can see that, sorry I know its a bit small):

What I need to do, is in Power BI, I need to group the questions together into their parent category title:

So that column 5,6,7,8,9 and 10 on the SharePoint list, so as "Personal Efficacy" in power BI.

Happy to provide any more information as required to get to the bottom of this as its going to hault what otherwise is a cracking end to end solution for my business.

Thanks

Dean