When merging two columns into one, I occasionally run into issues. I have a solution, however, it doesn't quite address the issue. (found here: Excel: Merge two columns into one column with alternating values)

As I understand two columns have to be one by one:

```A       B       C
==================
A       1       A
B       2       1
C       3       B
2
C
3
```

To get the above solution in the C column I should use:

`=INDEX(\$A\$2:\$B\$9;ROUND(ROW(A1)/2;0);MOD(ROW();2)+1)`

I, therefore, input data such as A1:B4 into the formula.

How can I do that if I only want to include columns A and D that have data instead of columns B and C? Alternatively, what if I had a column from sheet A and another from sheet B?

Oct 7, 2022 in Others 584 views

1 answer to this question.

This equation is completely adjustable. Your two distinct columns can be on separate papers. Additionally, you can place the Result column wherever you choose.

```=IF(ISEVEN(ROW())=FALSE;INDEX(\$A\$4:\$A\$20;ROUND((ROWS(\$A\$4:A4)/2);0));INDEX(\$B\$6:\$B\$24;ROUND((ROWS(\$B\$6:B6)/2);0)))
```

answered Oct 7, 2022 by
• 63,700 points

How to split columns into two sub columns under their parent column using python in excel

Use str.split: df[['pre', 'post']] = df['Column A'].str.split(r'\s*-->\s*', expand=True) print(df) # Output ...READ MORE

How to compare two excel sheets

How to compare two excel sheets , ...READ MORE

How to get columns from Excel files using Apache POI?

The only way to see all the ...READ MORE

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE