Continuing the discussion from Best transformations to deal with joined cells?:
Yes please, just needed "Fill Right" transformation.
"Fill right" transformation is confirmed for version 3.6 planned for release in late June.
Cheers. 100s of open data spreadsheets released by governments need this transformation.