Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Transform Data

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.

 

GeographyProductLatest 4 Week Pd Ending 08-08-21Latest 4 Week Pd Ending 08-08-21Latest 4 Week Pd Ending 08-08-21Latest 4 Week Pd Ending 08-08-21Latest 4 Week Pd Ending 08-08-21Latest 4 Week Pd Ending 08-08-21Latest 4 Week Pd Ending 08-08-21Latest 4 Week Pd Ending 08-08-21
  Dollar Sales CYDollar Sales LYUnit Sales CYUnit Sales LYACV ($MM) CYACV ($MM) LYPrice per Unit CYPrice per Unit LY
DeCA Total CONUS-RMA - MilitaryVALUE ADDED SALADS1934930.622013898.3726439834660460046002.6635830682.412836724
DeCA Total CONUS-RMA - MilitaryFE VAS991159.61069014.09425197498511460046002.3310597212.144414246
DeCA Total CONUS-RMA - MilitaryVAS BLENDS558910.13604531.16211929249256460046002.6372517682.425342459
DeCA Total CONUS-RMA - MilitaryVAS REGULAR GARDEN49335.6643061.853197427963460046001.5429930571.539958159
DeCA Total CONUS-RMA - MilitaryVAS GARDEN PLUS44364.7544002.342503625713460046001.7720382651.711287675
DeCA Total CONUS-RMA - MilitaryVAS KITS826507.76839184.78282304318025460046002.9277224552.638738401
DeCA Total CONUS-RMA - MilitaryVAS SPINACH71000.5492801.493989054215460046001.7799082481.711730886
DeCA Total CONUS-RMA - MilitaryVAS SHREDS73659.4387485.125447468904460046001.3521942581.269666783

 

 

Need Help