I've an excel file with merged cells. Dropping the picture below.
What I'm trying to do is, after loading to Alteryx, copy the 'Name' Jane from 1 to 5. (Jane should come in all 5 row of 'Name' column). similarly, Krishna should appear in 6 to10. Until here, I did it with MULTI-ROW FORMULA TOOL.
Same logic is working perfectly for column 'Event' and 'Time'.
So the challenge I'm facing here is,
1) This is a sample excel. The data and number of columns are randomly created by me. For each column, I'm using separate Multi-Row Formula Tool. What we'll do if we've 100 columns with merged cells? using 100 multi-row formula tool isn't practical, right? How can I solve this?
2) When I'm using this tool, the condition is if isnull([Name]) then [Row-1:Name] else [Name] endif. That is, if a cell is null, that cell will get updated with previous row value. ie. Row-1.
So for row 11, which is not a merged cell, but an empty cell or a null value cell, this also will get updated with Row-1 value. ie. Krishna. Row-1 should only work if it's a merged cell.
These are the two challenges I'm facing. Any help would be highly appreciated.
- Krishna