jeudi 15 février 2018

Get all rows from Google Sheet in random order

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