Hey Guys, in a bit of a pickle. How do I transpose cells from Columns to rows using a macro and also include the Asset Number and Date next to its respective element.
<tbody>
Asset Number
Date
Iron
Cr
Nickel
Al
Pb
Cu
Silver
TA20
12/12/2018
24
25
26
52
45
85
65
TA22
10/04/2018
65
875
45
895...