Snasui Excel Forum

Hi Dear,

I need your help how to return value from two columns to the another columns with swapping columns.
I need results in color cells


Thanks

You can use these formulas,

1. C2
   =IF(ISODD(COLUMNS($C2:C2)),INDEX($A$2:$A$5,INT((COLUMNS($C2:C2)-1)/2)+1),"")
   Enter > Copy to the right
2. C3
   =IF(ISODD(COLUMNS($C2:C2)),INDEX($B$2:$B$5,INT((COLUMNS($C2:C2)-1)/2)+1),"")
   Enter > Copy to the right

it is working thank you so much