I have a table of number entries. Say, for each Product (rows) a number of purchases on each Date (columns).
I'd like to turn this into one entry for each number on the 2D table. Example:
Is there a way to do this with formulas, without having to dive into a script to run each time I update the data?