2 ms·
Can you point me to an article that shows a simple way how to do a simple SQL-like join (no aggregation) of two regions in the same spreadsheet? Two source tabl
by dgudkov 5y ago
Can you point me to an article that shows a simple way how to do a simple SQL-like join (no aggregation) of two regions in the same spreadsheet? Two source tables, and one result table - all in the same spreadsheet.
Something that is as simple as this: https://www.youtube.com/watch?v=RYCtoRTEk84 https://www.youtube.com/watch?v=RYCtoRTEk84
- tomnipotent 5y agoI sent you two links with information, including images that show the process. Here's a video of the process: https://support.microsoft.com/en-us/office/merge-queries-and-join-tables-cbd17828-7a50-4dc6-9aac-20af4ef6d8a6 https://support.microsoft.com/en-us/office/merge-queries-and... Here's another video: https://www.youtube.com/watch?v=BV3srtI20Bo https://www.youtube.com/watch?v=BV3srtI20Bo
- dgudkov 5y agoThank you. I didn't know this. I wouldn't call the process easy, but it's relatively straightforward.