VBA / Power BI for combining multiple months TB

Trial balance for different months needs to be combined in one file while fetching period balance and year-to-date balance. Refer screenshot for file structure. Fir Act type "B", need to get year-to-date balance while for act type "O" need to get current period balance.