Link to download Excel file: [ Ссылка ]
TRANSPOSE huge data in rows across the columns, Paste/Special/Transpose, TRANSPOSE function, TRANSPOSE with ROW and MOD, Life saving trick using OFFSET function to transpose huge data. Using IF with ROW & MOD to trigger OFFSET to transpose data.
![](https://s2.save4k.ru/pic/vx7yX-m7GTk/maxresdefault.jpg)