1. Your data is not presented consistently in your spreadsheet. Sometimes you have Test-1 and other times you have Test -1. Spacing is importing in the formattting of your data to get proper results.
2. An alternative solution is using Power Query to split your data and then unpivot it.
3. Once unpivoted, it is loaded into the Data Model (Power Pivot)
4. In Power Pivot, create a new measure using concatenex (DAX feature)
You can see it all in the attached file.