How to show geo information from 2 sheets on one Looker Studio bubble map chart?

[optimus]

Hi,
I need some help.
I have a google sheet that I want to connect to a Looker Studio bubble map chart.

This google sheet have 2 sheets:
1. Clients (Client name, Client address, Some more client information)
2. Vendors (Vendor name, Vendor address, Some more Vendor information)

I want to show the clients and vendors on the same Looker Studio bubble map chart together - But the issue is that I can choose only on of them at a time. 

I tired with blended data - but still I can choose only one set of geo field at a time (Client adders or Vendor adders) 

How can I show both of the sheets information on the same map?

Thanks!
Ram

[ArkadyZagdan]

@optimus 
Add a new column,, label it somehhow like (type) withh two options ( Client, vendor) and add breakdown dimension and use different color fort both.
It will  display vendors using onen ccolor and cclientts using anotthhehr onne.

[optimus]

Hi @ArkadyZagdan - Thanks.
I added a type column and if I set them both in one google sheet it's working o.k.
The issue is when I have one list in one google sheet and another in another google sheets and I want to show them together on the same map.

I ended up creating a 3rd google sheet that import the data from the 2 original google sheets and merged them and then used this new google sheet as the source of the map in looker studio.

I wish there was a better and easy way to do it.
Thanks!
Ram