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 value in the new row and to copy cell 2 from that 1st row to cell 2 of the new row and any cells that have data. then repeat the process until there are no more data in the column.
