The workbook named Quarterlygnpdata.xlsx contains quarterly GNP data for the United States (in billions of 1996 dollars). Extract this data to three separate columns in which the first column contains the year, the second column contains the quarter number, and the third column contains the GNP value.

Transcribed Image Text:

B3 DATE X ✓ fx A GNPC96 1 2 3 1950.1 1618.4 4 1950.2 1667.2 5 1950.3 1733.1 6 1950.4 1763.9 7 1951.1 1782.9 8 1951.2 1814.9 9 1951.3 1851.6 10 1951.4 1855.8 11 1952.1 1876.7 12 1952.2 1878.2 13 1952.3 1889.9 14 1952.4 1951.9 15 1953.1 1987.4 16 1953.2 2004.3 17 1953.3 1990.2 18 1953.4 1958.6 19 1954.1 1949.7 20 1954.2 1952.6 21 1954.3 1973.7 22 1954.4 2014.1 23 1955.1 2071.6 24 1955.2 2104.3 25 1955.3 2132.4 26 1955.4 2143.9 27 1956.1 2136.4 28 1956.2 2152.8 29 1956.3 2150.8 30 1956.4 2184.1 31 1957.1 2198.8 32 1957.2 2195.0 33 1957.3 2215.5 34 1957.4 2189.2 35 1958.1 2131.0 36 1958.2 2143.6 B Year C Quarter GNP E LL