I want to know if it's possible to accomplish something on Google sheets. Essentially, I want to get the value of various cells across 2 different sheets. I want to get all of the values, but in a random order. Here's an example
Sheet A
A1: 1
A2: 2
A3: 3
Sheet B
A1: 4
A2: 5
A3: 6
Sheet C (retrieving data from Sheets A & B)
A1: 1
A2: 4
A3: 2
A4: 3
A5: 6
A6: 5
In Sheet C, all values are dynamically retrieved using a cell reference from sheets A & B. Each value is retrieved once, and all values are retrieved.
I appreciate the time
Aucun commentaire:
Enregistrer un commentaire