To create a dynamic length range I think I should be using
INDIRECT() in some way but just can't quite get my head around how.
How can I use the function
counta() as the end of each column's chosen range?
I'm using Google Sheets but I suspect the answer may be the same for Excel as well.
I have two columns full of string data that are dynamically pulled from a website, therefore I can't know for certain how long the columns will be. I wish to combine them into a single column, so have been using
It works but of course I end up with a whole bunch of blanks between the two merged columns, since I am combining each column up to row 100 when there is only data for maybe 50 or so rows each.
I would like to specify the ending of each range, to be the count of that range. Something like this (which is of course totally improper syntax):
That's why I need the solution for Part 1.