The INDIRECT function provides you to create dynamique references by using the cells' contain as part of your references.
Discover how you can easily create a dynamic dropdown list (data validation) when your source of data will be updated with Tables
How to extract a sample of data random data? A combination of a random number and the function INDIRECT will return the result expected.
You can unstack data from 1 column to many with the function TRANSPOSE and INDIRECT. Explanation is this article.
Easily unstack data in Excel with this simple guide. Learn how to quickly rearrange your data for better analysis and visualization.