Lookup and copy a range of cells and paste them into 1 row for easy chart plotting

[xWiZardx]

Hi,

Is there any formula or function I can use to lookup and copy a range of cells (multiple rows and columns) and paste them into 1 row so that I can select them to plot a scatter chart?

Please see the attached image, the table on the left is where I input my data, the table on the right is what I hope to achieve so that I can plot the scatter chart below easily.
Or feel free to suggest a better way for me to plot the scatter chart if you know of any.

Thank you for your help!

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Lookup and copy a range of cells and paste them into 1 row for easy chart plotting
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.