Hi All,
Having a hard time trying to transform this Excel data....
Trying to get it into the best possible layout to import. Thoughts?
Geography is cell A1
Here is a snippet of the data....so there are more geographies than just what is listed and also more time frames for measures across columns.
| Geography | Product | Latest 4 Week Pd Ending 08-08-21 | Latest 4 Week Pd Ending 08-08-21 | Latest 4 Week Pd Ending 08-08-21 | Latest 4 Week Pd Ending 08-08-21 | Latest 4 Week Pd Ending 08-08-21 | Latest 4 Week Pd Ending 08-08-21 | Latest 4 Week Pd Ending 08-08-21 | Latest 4 Week Pd Ending 08-08-21 |
| | | Dollar Sales CY | Dollar Sales LY | Unit Sales CY | Unit Sales LY | ACV ($MM) CY | ACV ($MM) LY | Price per Unit CY | Price per Unit LY |
| DeCA Total CONUS-RMA - Military | VALUE ADDED SALADS | 1934930.62 | 2013898.3 | 726439 | 834660 | 4600 | 4600 | 2.663583068 | 2.412836724 |
| DeCA Total CONUS-RMA - Military | FE VAS | 991159.6 | 1069014.09 | 425197 | 498511 | 4600 | 4600 | 2.331059721 | 2.144414246 |
| DeCA Total CONUS-RMA - Military | VAS BLENDS | 558910.13 | 604531.16 | 211929 | 249256 | 4600 | 4600 | 2.637251768 | 2.425342459 |
| DeCA Total CONUS-RMA - Military | VAS REGULAR GARDEN | 49335.66 | 43061.85 | 31974 | 27963 | 4600 | 4600 | 1.542993057 | 1.539958159 |
| DeCA Total CONUS-RMA - Military | VAS GARDEN PLUS | 44364.75 | 44002.34 | 25036 | 25713 | 4600 | 4600 | 1.772038265 | 1.711287675 |
| DeCA Total CONUS-RMA - Military | VAS KITS | 826507.76 | 839184.78 | 282304 | 318025 | 4600 | 4600 | 2.927722455 | 2.638738401 |
| DeCA Total CONUS-RMA - Military | VAS SPINACH | 71000.54 | 92801.49 | 39890 | 54215 | 4600 | 4600 | 1.779908248 | 1.711730886 |
| DeCA Total CONUS-RMA - Military | VAS SHREDS | 73659.43 | 87485.12 | 54474 | 68904 | 4600 | 4600 | 1.352194258 | 1.269666783 |
