Excel Add-In: Flattened Data with Rows Labeles

kjochim

Hello!

I'm using the excel add-in and, unlike when I export from the model, I am unable to flatten my data and retain all the row labels (A below). Instead they get grouped like they do in the module display (B below is what the add-in is giving me). Is there any way to use the add-in and have it pull the data into excel similar to how it would look in an exported csv (i.e. all rows having all labels as is figure A)? Thanks!

A

B

Dikshant

@kjochim,

That's the difference between the export and when you read the data via Excel Add-in.

Refer this link below for the workaround to auto populate the data in excel similar to Anaplan Export.

https://spreadsheetplanet.com/fill-blank-cells-with-value-above-in-excel/

kjochim

Someone informed me that the data is actually there but defaults to white. If you change the font color to black you can see it!