Hello, I am new to Stata and currently using Stata 15.1. I am working on a project involving firms and rivals. I want to input certain variable of the focal firms for the rows containing rivals. My data is in the following format.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str5 all_id str2 riv_id float cagr
"100P1" "r0"   .345
"100P1" "r1"  .5434
"100P1" "r2"    .45
"100P1" "r3"    .23
"101P1" "r0"  .5654
"101P1" "r1"   .243
"101P1" "r3"   .234
"101P1" "r4"   .123
"101P2" "r0"   .126
"101P2" "r2"   .567
"101P2" "r4" .45645
"101P2" "r5"   .789
end
I want to create another column with the values of variable "cagr" for each all_id, to be replicated for the each rival (riv_id), as below. I am not able to find a solution to this. Can someone tell how to achieve this?

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str5 all_id str2 riv_id float(cagr cagr_focal)
"100P1" "r0"   .345  .345
"100P1" "r1"  .5434  .345
"100P1" "r2"    .45  .345
"100P1" "r3"    .23  .345
"101P1" "r0"  .5654 .5654
"101P1" "r1"   .243 .5654
"101P1" "r3"   .234 .5654
"101P1" "r4"   .123 .5654
"101P2" "r0"   .126  .126
"101P2" "r2"   .567  .126
"101P2" "r4" .45645  .126
"101P2" "r5"   .789  .126
end