Quote:
Originally Posted by ArviLaanemets
An easy one
|
Thanks for help!
Your formula works but not for what i need...
I have attached an excel in which I have a formula for horizontal transposition.
=OFFSET($A$2,COLUMNS($A2:A2)-1+(ROWS($2:2)-1)*24,0)
if it's possible, based on this formula can you make it work vertically, please? In groups of 4, 10,15, etc ... as in the example in excel.