https://kidb.adb.org/mrio#:~:text=ADB%20MRIO%20at%20Constant%202010%20Prices%20(2019)

Attached link is a global input-output database. It comprised 63 countries and each country has 35 sectors.

First, I want to aggregate the countries along with their sectors (both rows and columns) as:
BRA, CAN, MEX, and ROW as “ROW”; AUS, TAP, KAZ, SRI, PAK, FIJ, BRU, BHU, KGZ, MLD as “ROA”; then,
retained these countries as is, PRC, JPN, KOR, BAN, CAM, HKG, INO, IND, LAO, MAL, MON, NEP, PHI, SIN, THA, VIE, US, GER; and then the rest of the countries as “EU”.

Then aggregate all the sectors (both rows and columns) as “OTH”, except for C4, C12, C13, C14 and C15 which are to be retained.

Then there are also F1, F2, F3. F4. F5 for each countries.
I want to aggregate the countries along with their Fs (both rows and columns) as:
BRA, CAN, MEX, and ROW as “ROW”; AUS, TAP, KAZ, SRI, PAK, FIJ, BRU, BHU, KGZ, MLD as “ROA”; then,
retained these countries as is, PRC, JPN, KOR, BAN, CAM, HKG, INO, IND, LAO, MAL, MON, NEP, PHI, SIN, THA, VIE, US, GER; and then the rest of the countries as “EU”.

The output should look like this: