@MayThongthum Table joins don't support one to many join that's why you are getting only 34 joined records. You may want to look into `Relate`. Now another way to do this would be to first use the `calculate geometry attributes` to add the `x` and `y` coordinates to the provinces dataset. Then use the join tool to bring over the `x` and `y` coordinates to the transposed table. Then use the `XY Table to Point` tool to convert the transposed table to a point feature class. Now use the `spatial join` tool to join the transposed point feature class to the province feature class using `one to many` join type.
The answer to this post can also help, ArcGIS Pro Join One to Many Join by Attribute
Question | Analyze | Visualize