This video demonstrates the benefits of using relative references when recording a macro in Excel. It also showcases the Do While Looping structure that is available in VBA: this helps us further automate the process of transposing individual records in our example.
------------------------