Hi all,

I'm not too familiar with using gravity data, so I am not sure what my dataset should look like.

I currently have two datasets. Dataset 1 shows a characteristic (var_1) for a given country in each of 3 years.
Dataset 1:
Country Year var_1 ...
ALB 2017 x1 ...
ALB 2018 x2 ...
ALB 2019 x3 ...
...
ZIM 2017 xn-2 ...
ZIM 2018 xn-1 ...
ZIM 2019 xn ...
Dataset 2 is the gravity dataset and shows bilateral variables for pairs of countries in each of the years.
Dataset 2:
Country Partner Year Bilateral Variable 1 ...
ALB ARM 2017 k1
ALB AUS 2017 k2
ALB AZE 2017 k3
...
ZIM UGA 2019 ku
ZIM UZB 2019 kv
ZIM ZAM 2019 kw
I'm not sure how the two datasets will merge.
In dataset 1, ALB takes the value x1 for var_1 in 2017. In the merged dataset, will this value x1 be repeated in every row that concerns ALB and 2017?

e.g (This is my thoughts)
Country Partner Year Bilateral Variable 1 var_1
ALB ARM 2017 k1 x1
ALB AUS 2017 k2 x1
ALB AZE 2017 k3 x1
ALB BEL 2017 k4 x1
ALB BLR 2017 k5 x1
ALB BRA 2017 k6 x1
... ... ... ...
Is this what the merged dataset will be?

I hope I have managed to explain this okay
Any help is much appreciated,

Thanks!