Thank you

How does this formula work please: =OFFSET($V$1,0,0,COUNTA($V:$V),1)