It headache when it need to fill down blank for multiple columns, Where it different from Microsoft Power Query
It have to use multiples multi-row tools.
It not elegant, hence I built one macro to solve this issue.
Limitation: the columns should not contains Tile_Num and Tile Sequence
It elegant, because 1 purpose, 1 tool.
a little macro explanation if you wondering:
Spoiler
1. instead of complex xml massage across multiple tool, I utilize Tile Tool to assign the groupby ID hence it reduce complexity and avoid the datatype issue.
2. it have 2 select tools, because 1 to remove groupby columns, another is to select data columns. I split them to keep thing simple.
3. Detour is used, because the tile tool will error when it have no groupby columns.
4. I hate nested macro, hence instead of nested macro for multi-row tool. I use dynamic replace for it
.
