formula: =concatenate(transpose(xxxxx)) highlight transpose (xxxx), press "ctrl" + "=" then delete front and back curly brackets "{ }" enter
