The Accounting Department at van Dyke Industries has produced a data set of the company’s quarterly sales revenue for the past five years in an unstacked arrangement. These data are provided in the file vandykeunstacked as shown in the following figure.

A financial analyst at van Dyke needs these data stacked so each record corresponds to one year and quarter. Convert these data so they are stacked and save the file under the name vandykestacked.xlsx.

Transcribed Image Text:

A B C D E Sales Revenue ($ thousands) Year QTR 1 QTR 2 QTR 3 QTR 4 12345 $562 $577 $578 $526 $599 $829 $578 $748 $735 $644 $639 $748 $785 $870 $861 $526 $1,228 $1,317 $841 $979 1234 5 69 7