Forum Discussion
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 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.
- 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? Could you help us to help you by following the recommendations in Welcome to your Excel discussion space! please?
