Merging multiple tables with same X axis and different Y axis

Hi all,

Trying to collect data for my work, and seeing who is refering to my business by month. Ideally, to change data sets like below: https://imgur.com/a/kZZtg1i into something more like this: https://imgur.com/a/Jlybyf9

While I can do it manually, but I did thought that I should consult the collective brain trust in here to see is there a way to do this more efficiently.

I did also had a look online to see is there is a solution but unfortunately I couldn't quite find what I was looking for. Thank you in advance.