Spreadsheet: 264024d1378750497-invert-excel-data-table-_ft__data_excel-_forum
Sheet: Sheet1

Friday | 2006-09-01 00:00:00 | 1315.57 | 1337.03 | 1312.92 | 1336.25 | 6017560000
Thursday | 2005-09-01 00:00:00 | 1309.03 | 1326.56 | 1306.48 | 1313.49 | 6175586000
Wednesday | 2004-09-01 00:00:00 | 1310.97 | 1319.14 | 1301.37 | 1303.21 | 5752957000
Tuesday | 2003-09-01 00:00:00 | 1323.11 | 1334.15 | 1312.63 | 1315.41 | 8755503000
Monday | 2002-09-01 00:00:00 | 1298.99 | 1323.7 | 1296.35 | 1323.7 | 7850956000
Friday | 1930-08-01 00:00:00 | 1300.44 | 1301.96 | 1285.05 | 1294.3 | 6075297000
Thursday | 2029-08-01 00:00:00 | 1283 | 1293.9 | 1273.7 | 1292.53 | 7905083000
Wednesday | 2028-08-01 00:00:00 | 1272.33 | 1294.08 | 1260.08 | 1275.76 | 11468745000
Tuesday | 2027-08-01 00:00:00 | 1321.66 | 1322.72 | 1290.27 | 1293.97 | 11490425000
Monday | 2026-08-01 00:00:00 | 1347.69 | 1354.39 | 1328.51 | 1329.18 | 8271787000
Friday | 2023-08-01 00:00:00 | 1368.56 | 1370.4 | 1337.99 | 1338.13 | 8615835000
Thursday | 2022-08-01 00:00:00 | 1341.66 | 1355.87 | 1325.78 | 1351.81 | 9718129000
Wednesday | 2021-08-01 00:00:00 | 1355.54 | 1374.02 | 1354.02 | 1355.14 | 7534952000
Tuesday | 2020-08-01 00:00:00 | 1378.87 | 1379.27 | 1353.02 | 1370.86 | 10272160000
Monday | 2019-08-01 00:00:00 | 1437.77 | 1438.78 | 1398.37 | 1398.48 | 7603136000
Friday | 2016-08-01 00:00:00 | 1441.72 | 1452.2 | 1440.74 | 1445.76 | 8199794000
Thursday | 2015-08-01 00:00:00 | 1458.51 | 1461.34 | 1447.82 | 1453.07 | 7515277000
Wednesday | 2014-08-01 00:00:00 | 1457.25 | 1462.66 | 1451.71 | 1460.63 | 8241676000
Tuesday | 2013-08-01 00:00:00 | 1443.25 | 1459.08 | 1442.08 | 1459.08 | 7519886000
Friday | 2009-08-01 00:00:00 | 1446.26 | 1446.47 | 1430.41 | 1432.25 | 7138657000
Thursday | 2008-08-01 00:00:00 | 1439.76 | 1455.08 | 1439.1 | 1447.16 | 8697592000
Wednesday | 2007-08-01 00:00:00 | 1420.11 | 1434.98 | 1417.43 | 1429.99 | 5983726000
Tuesday | 2006-08-01 00:00:00 | 1411.97 | 1440.25 | 1409.87 | 1429.39 | 9338272000
Monday | 2005-08-01 00:00:00 | 1416.78 | 1427.93 | 1405.71 | 1424.31 | 4710745000
Friday | 2002-08-01 00:00:00 | 1440.43 | 1442.17 | 1408.57 | 1420.94 | 7867919000
Thursday | 2001-08-01 00:00:00 | 1437.58 | 1443.65 | 1425.51 | 1437.51 | 6226070000
 | 2013-08-01 00:00:00 | 1437.58 | 1443.65 | 1425.51 | 1437.51 | 6226070000
 | 2013-08-02 00:00:00 | 1440.43 | 1442.17 | 1408.57 | 1420.94 | 7867919000
 | 2013-08-05 00:00:00 | 1416.78 | 1427.93 | 1405.71 | 1424.31 | 4710745000
 | 2013-08-06 00:00:00
 | 2013-08-07 00:00:00
 | 2013-08-08 00:00:00
 | 2013-08-09 00:00:00
 | 2013-08-13 00:00:00
 | 2013-08-14 00:00:00
 | 2013-08-15 00:00:00
 | 2013-08-16 00:00:00
 | 2013-08-19 00:00:00
 | 2013-08-20 00:00:00
 | 2013-08-21 00:00:00
 | 2013-08-22 00:00:00
 | 2013-08-23 00:00:00
 | 2013-08-26 00:00:00
 | 2013-08-27 00:00:00
 | 2013-08-28 00:00:00
 | 2013-08-29 00:00:00
 | 2013-08-30 00:00:00
 | 2013-09-02 00:00:00
 | 2013-09-03 00:00:00
 | 2013-09-04 00:00:00
 | 2013-09-05 00:00:00
 | 2013-09-06 00:00:00
 | Hi Excel Forum,
 | The data I get from a website is an Upside Down List  = Last Date on first Line
 | The length of the list of dates can vary
 | I need the Date in the MM/DD/YY Format
 | In Green Fill Collored Cells   B29 to B54     I have converted the incoming   Date / Data into MM/DD/YY
 | Unusual formula     but it works
 | Could you please tell me how to invert the List of Data Cells C1 to G26     Yellow Fill Colour
 | and put the inverted data into cells C29:G64 the Grey Filled Area     to  the right of the corresponding dates
 | Thanking you in advance
 | Best regards,
 | Derek