Separating grouped cells to different columns

Hi Everyone,

An accounting report from ERP software provides the data in the below format:

I want the data to be organized in the below format - The grouped cells to be in separate columns similar to how a pivot table would display the data. Is there any feature in Excel to do this?

Thanks in advance!