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

Copper Contributor

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. 

2 Replies



Could you help us to help you by following the recommendations in Welcome to your Excel discussion space! please?

Share Excel file you’re working with or sample file with data – please remove all confidential and PII data

Could you share a file and expected result?