Inserting rows every time an account is different

I have balances from various companies in multiple columns.

Goal is different parent accounts should be on different rows.

Company A has 4 Sales accounts in C2:C5 while Company B has 6 Sales accounts in G2:G7.. then next account should start in row 8 for both companies.

How should I insert rows per company where needed? Might be clearer in excel file which I attached.

Thank you.

Here is a formula base proposal illustrating how this might be accomplished.
Put Sales, Advertising and Payroll into J2:J4
Populate K2:M4 using: =COUNTIFS(INDEX($A$2:$G$11,,MATCH(K$1,$A$1:$G$1,0)),"*"&$J2&"*")
Populate N2:N4 using: =SUM(MAX(K2:M2),1)
Populate P2:P21 using: =IFERROR(INDEX(J$2:J$4,AGGREGATE(15,6,(ROW(J$2:J$4)-ROW(J$1))/(N$2:N$4>=ROWS(A$1:A1)),1)),"")
Populate the Company columns using: =IF($P2="","",IFERROR(INDEX(A$2:A$11,AGGREGATE(15,6,(ROW(A$2:A$11)-ROW(A$1))/(ISNUMBER(SEARCH($P2,A$2:A$11))),COUNTIFS($P$2:$P2,$P2))),""))
Populate the Amount columns using: =IF(Q2="","",INDEX(B$2:B$11,MATCH(Q2,A$2:A$11,0)))
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.