transpose but copy 2nd row and beyond if filled to another row.

In windows, office 365, how do I transpose or whatever the function is to take lets to say a value in cell 1, then if cell 2, 3, etc are not blank create a new row and value in cell 1 to be the first...