VBA Macro - Selective Copy And Transpose

I have a spreadsheet which contains many rows (>3000) and a few columns.

I would like to make a macro that will copy specific cells depending on the number from another cell (from the first column) and then transpose the corresponding values. My current problem is that the values I'd like to copy (countries) are on a row (horizontal) and I need it on a column (below "Countries") next to the car models (in black: the current sheet, in red: my target):

Number of Countries
Cars
Countries

A
FJ

A
UK

[Code] .......

Is it be possible to create a macro that transposes automatically the countries from the right into the third column (like 90 degrees against the clockwise direction)?