Snasui Excel Forum

Hi there,

I need to transpose one row length data to 3 columns length.

I try index and offset with mod but no luck

TY

I attach a sample

...

B5

=IFERROR(IF(COLUMNS($B5:B5)>3,"",INDEX($B$2:$M$2,ROWS(B$5:B5)*3-2+COLUMNS($B5:B5)-1)),"")

Norkaz

Thank you, always very helpful