Here is how I used OFFSET and 5 other functions to convert a data range into a single column in Excel:
You can download the file here to follow along. If you get a preview, look for the download arrow in the upper right hand corner.
CORRECTION TO VIDEO: I used 6 functions, not 7 in this formula!
This process is quite a complex one and I strongly encourage you to watch the video to get the full explanation. Below I will give you the basics that I used to achieve this.
The scenario is that I have a data range:
I want to create a formula to convert it to a single column:
I will use this list of functions:
To produce this formula:
Now, go watch the video and see how I did it (please….)!