# value ,empty values while creating model and hierarchy

[lavanyareddy99]

hello team,

i am importing data from excel to create a planning model,there are some empty cells which has no data and having #value,please assist how can i create a model along with hierarchy creation for which few rows have empty values.

[N1kh1l]

lavanyareddy99

The below video should help you on creating the model from file and second one walks you through the process of creating hierarchies, I think in your case its level based hierarchies.

https://www.youtube.com/watch?v=AMgp6nqoC7c&t=167s

https://www.youtube.com/watch?v=0YVTCbpdcmk&t=47s

Also if you wish you can replace your "#" Products with "No Product" or any suitable ID during data wrangling.

Hope this helps !!

Nikhil