Image – 1 shows the raw data. I go to Developer Tab > Code Group and select “Use Relative References” and then start recording a macro, do certain operations and stop recording the macro. The data after I stop recording is shown in Image – 2. I then selected cell C1 and run the macro. Which picture demonstrates the final version of the data? 

Image-1

Image-2