I have the next table:
A B C D E F G H
2 Order Qty Description Desc1 Desc2 Desc3 Cost
3 456 25 Gloves, rubber 1.91
4 Mfg: McMaster Carr
5 Sch B: 3920.10.0000
I need a macro to transpose rows D3,D4,D5 to E3, E4, E5 respectively.
My real data are thousand of lines, and have a...