Hi there,

Currently we don't have such a feature to directly do that for you. However, there is a workaround with Kutools' features (you can download and try it for free for 30 days):

1. Select the range 'How data currently exports'!$A$1:$I$7, then on the Kutools tab, click Range > Transpose Table Dimensions.



2. In the pop-up dialog, choose Cross table to list, and click the range-selection icon under the Results range section to select a cell where you want to output the result (here I created a new sheet and select the cell A1).



3. You will see the result as shown below. Now select the range C1:C48 and then on the Kutools tab, click Range > Transform Range.




4. In the pop-up dialog, choose Single column to range. In the Fixed value box, enter 2. Once finished, click OK.



5. Specify the output range in the next pop-up dialog (here I select D1). You will see the results as shown below.



6. Delete the column B and C. Select column A and then click Select > Select Interval Rows and Columns.



7. In the pop-up dialog, choose Rows. Under Options, set 1 for both interval and rows number. Once finished, click OK. (Do not check Select entire rows)



8. Right-click on any of the selected cells, and then click Delete. In the pop-up dialog, select Shift cells up.



9. Now you will see the result as shown below. You can add headers for the table.