I need an Excel Expert

Need help with cleaning up data using Power Query. Having trouble with a system generated report that has the beginning and ending balances on the same row for each Program # category. The way the system generated report is structured is that column "G" repeats the beginning balance for every row, and column "M" repeats the ending balance on every row. This is accounting specific in that the beginning balance will be followed by debit and credit amount columns. Need help with using Power Query to isolate the beginning and ending Program # category balances into separate unique rows. How do I do this?