Split row into multiple rows, while combining columns

Thanks so much Ashish, this was very helpful!

I just have one more question. I had to replicate this process for multiple reports on risk, issues, milestones etc and it worked perfectly. But now I need to do it for a summary table which lists multiple RAG status for multiple projects, and I'm not sure how to finish.

I have gotten to the point where I have data as below:

Effectively each project has three rows where all data is the same, except row 1 has the columns populated for  "Overall status", row 2 has "Cost status" columns populated and row 3 has "Time status" columns populated.

I am trying to combine these rows or otherwise get a single row with all status data.

Any help would be greatly appreciated.

Kyle