Snasui Excel Forum • re-arrange data

Page 1 of 1

re-arrange data

Posted: Sat Sep 25, 2021 9:31 pm

by sna

Hi Dear,

I need your help how to re arrange data as in color cells .
I attached a sample workbook

Thanks

Re: re-arrange data

Posted: Sat Sep 25, 2021 10:35 pm

by norkaz

...

A11

=IFERROR(INDEX(A$1:A$8,AGGREGATE(15,6,ROW($A$1:$A$8)/($A$1:$A$8<>""),ROW(A1))-INT(COLUMNS($A11:A11)/2)),"")

Norkaz

Re: re-arrange data

Posted: Sun Sep 26, 2021 7:06 am

by sna

always fast response and nice solution,thanks