Unpivoting List

[shanekerr]

Hi guys,

I've tried a range of functions and formulas to try and effectively unpivot this list of university programs. Anyone got any ideas how to do it dynamically? See file here: http://bit.ly/2brupU4

Cheers

Shane

 

[Derek Brown]

I have not looked at your file (I do not download external files) but perhaps the following may give you some ideas:
https://www.youtube.com/watch?v=mxmfOoxIVCQ
https://www.youtube.com/watch?v=yX-QNxaOj9c