Hello there!
Is it possible to have one formula (in a single cell) that creates a table/matrix/dynamic array?
Here is the business need:
* product IDs by row
* years by column
* values are sales amount
(see the example below)
All this data is in an excel table with the following columns: product id, year, sales amount (also see below).
Bookmarks