I have a table which auto-calculates functions on one sheet and another sheet which has raw information.
Is is possible to press a button or run a command that maps the raw data (2 column, not side by side and I can’t make them side by side for simple copy-paste) to the data/analysis column of the other sheet?
The Problem:
Data Sheet (want name + id):
NAME (THINGS) ID
Function Sheet:
NAME ID ANALYSIS
Right click → ??? → Function Sheet auto fills with the appropriate columns (but only the rows that I selected)
Is this possible?