1 of 1 people found this helpful
If you Join instead of Blend, all the data will be in one table. However your table structure probably precludes that as you will have a many to many relationship.
I don't think there's any way to do this in the way you want. You could have this table on a dashboard, with two other sheets (one from each source) that either has just a text label like "View data from source A", or you could actually use filter actions to show the data itself.
Many thanks, Alex.