Importing Excel that includes merged cells?

[Oz]

When importing an Excel file, which contains merged cells, Alteryx only recognises the value of the first merged cells and not all the cells which are merged. I am attaching an example of it. Is there any solution inside Alteryx (without prior Excel data manipulation) which would consider that all the cells within merged range have a value?

Thank you,

Gorazd

[Joe_Lipski · Accepted solution]

Hi @Oz 

I would solve this issue by using a Multi-Row Formula with this formula: IF ISNULL([F1])THEN [Row-1:F1] ELSE [F1] ENDIF

The module is attached.

Hope this helps,

Joe

[Lee]

Have you done something similar with merged columns?