rows to column / data transpose

Any code for this one? I need help. Any help is highly appreciated. Thanks

rows to column / data transpose

Any code for this one? I need help. Any help is highly appreciated. Thanks

Return the address of last non-empty string cell

been researching this for a while and can’t find a solution. Thanks for the help.