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 724 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)))
```

• 63,720 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

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