Posts by Roger Mello • 21 points
2 posts
-
1
votes4
answers1444
viewsA: Excel transpose row to column and preserves columns and replicate them in row
I advise to use this macro which I did, everything will be done automatically, just create the macro and run. If the line is not on A1, just change the location of the line inside the macro. Sub…
-
1
votes4
answers1444
viewsA: Excel transpose row to column and preserves columns and replicate them in row
Try using the special paste. Copy the cells you want and press Ctrl+Alt+V if you want to transpose.