Did you look at the code I sent?
I think it does what you're asking.
What I described finds non-blank values in B
and combines them with the value of A6.
If you understand THAT loop, you can write another loop
with the same technique to loop  through the values of "A".

The problem with what you wrote with ticker = ticker + offset(1,0)
is that it first, it is trying to COMBINE the tickers. (if all other problems
where fixed) That means that if the value in A6 was, say: "paul"
and the value in A7 was "Steve", and the value in A8 was "John",
then the first loop would have Paul"date1", Paul"date2", but the
second loop would be PaulSteve"date1", PaulSteve"date2", the third
loop would be PaulSteveJohn"date1", PaulSteveJohn"date2"... so, you see
that's not gonna work. Also, "offset" is an offset from the currently SELECTED
cell. you're not actually SELECTING the first cell, you're letting the program
look at the contents of the first cell.

Take a look at my previous response.
If you give me some sample data (5 values or so) and sample file names,
I can write it for you, but will that help  you learn??