transposing

I have a dataset that spans around 50+ columns, however the names are all under a cell in row 2 separated by commas. Example: For A2, you can see the full string as its the same in each cell in E2, I can use Data > Text to Columns and separate this fine into row 3 for instance. Then using the...