I have a block of data for scatter plots - about 500 rows, single column of X values and 10 columns of Y values. I have a second block of data for scatter plots with 200 rows, single column of X values and as high as 20 columns of Y values. It's easy to plot separate scatter plots for each block of data. Is there a simpler way to combine both scatter plots into one than manually selecting X and Y data 20 times over. Both groups of scatter plots have similar X and Y ranges so that's not going to be an issue. Example images of each scatter group is in the links below. Appreciate the tips.

[Example Scatter Group 1:](https://i.stack.imgur.com/tP2LE.png)
[Example Scatter Group 2:](https://i.stack.imgur.com/0QYMY.png)

EDIT: PowerQuery Approach

@QHarr Thank you for suggesting the approach. Unfortunately, when I try and **Merge** the tables on the first column, it doesn't work as expected. Maybe I've not uderstood the steps properly but I think it's because my x-axis value (the common column 1) are not exactly the same on both tables. I.e the Simulation data has somewhat ordered coordinate values like 0.001, 0.002, 0.003... and so on whereas the experimental data is more random 0.00121, 0.00189, 0.0022 and so on. This might be why I see the "The selection has matched 1 out of the first 460 rows" on the **Merge** window.
[Merge Window Screenshot](https://i.stack.imgur.com/H6azO.png)