Forum Discussion
Solved
Combining columns from multiple tables
Hi , I was wondering if anybody could help me solve an issue I am facing. I have 2 tables on different sheets but I need to get one column on a new sheet which combines the the col ID and ITM...
Its really hard to merger two columns to old versions of excel. You can achieve it by below formula to Excel-2016.
=IFERROR(INDEX(CHOOSE({1,2},Sheet2!$A$2:$A$6,Sheet3!$A$2:$A$6),IF(MOD(ROW(A1),COUNTA(Sheet2!$A$2:$A$6))=0,COUNTA(Sheet2!$A$2:$A$6),MOD(ROW(A1),COUNTA(Sheet2!$A$2:$A$6))),ROUNDUP(ROW(1:1)/COUNTA(Sheet2!$A$2:$A$6),0)),"")Download the attached sample file.
Its really hard to merger two columns to old versions of excel. You can achieve it by below formula to Excel-2016.
=IFERROR(INDEX(CHOOSE({1,2},Sheet2!$A$2:$A$6,Sheet3!$A$2:$A$6),IF(MOD(ROW(A1),COUNTA(Sheet2!$A$2:$A$6))=0,COUNTA(Sheet2!$A$2:$A$6),MOD(ROW(A1),COUNTA(Sheet2!$A$2:$A$6))),ROUNDUP(ROW(1:1)/COUNTA(Sheet2!$A$2:$A$6),0)),"")Download the attached sample file.