Or try Pivot Table.
Move AAA and BBB above your numbers, like this:
AAA
Jan 15
Feb 20
Mar 25

BBB
Jan 100
Feb 120
Mar 130

Data Pivot Table Multiple consolidation ranges
Ranges: Enter A1:B4 , A6:B6 and so on
Layout: Drag Row into COLUMN and Column into ROW
DATA is Sum of Value
Options: Uncheck Grand Totals and AutoFormat
The result will look like this:

Column Jan Feb Mar
AAA 15 20 25
BBB 100 120 130