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

Excel merged cells sample.xlsx

Joe_Lipski

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

Merged Cells.yxmd