I think this one probably needs a VBA solution to rearrange the data. Can anyone help?

https://www.excelforum.com/excel-pro...f-columns.html