how to add all occupied cells in one row

Hi all
could someone explain how I make this work
all I need to do is add occupied cells from A1 to the first empty column

thanks

Please Login or Register  to view this content.