Problem
A user (me) inputs values of an MxN matrix starting at cell A1 in Sheet2. Create a run button on Sheet2 that executes a macro named problem2.
This macro solves the following problem:
• Determine the number of rows and columns of data on the worksheet and store these values in variables named M and N.
• Create a MxN array named array1.
• Obtain the values from the worksheet and store them in array1.
• Calculate the transpose of array1 and output the transpose one row below the original MxN array. For example, if the user inputs the following array, the macro will calculate the transpose after the run button is clicked and output it to the worksheet, This macro should work for any MxN array input by the user. Hint: You can check if there is only one row or one column by checking if ActiveCell.Value = "" for cells A2 and B1. Do not use the built-in Excel function Transpose. Use the Option Explicit statement for this macro. Assume the user will input all necessary values on the worksheet before clicking the run button.