Snasui Excel Forum

Hi Dear,

I need your help to convert two cols to rows .the result as in highlight cells.
I need one formula to drag across it would come up like the highlight cells

Best Wishes

Here's an attached file

...

D2

=INDEX($A$2:$B$99,ROW(B1)+(INT(COLUMN(B2)/2)-1)*3,MOD(COLUMN(B2),2)+1)

Copy to the right-hand side and down

Norkaz

Thank you so much for your quick response.always nice

..

You are very welcome.

Norkaz