CODEWITHSUNDEEP
excel
Ashish Aggarwal
Ashish Aggarwal

Reputation: 3026

Merge two columns of a table in excel

I want to merge 2 columns of a table in excel.

In excel if we want to merge two cells then there is an option called Merge & Center which id the same thing I want.

But when I create a tbale then select two columns and try to apply the same but in that case Merge & center button is disables. Is there any way in excel to merge two columns of a table.

Upvotes: 1

Views: 241

Answers (2)

safejrz
safejrz

Reputation: 544

You may have data on both cells and thats why that wont work, merge cells only work with empty cells and other cell (with data or empty too).

I'll create a macro to do the repetitive work.

Upvotes: 1

Jakub Zaverka
Jakub Zaverka

Reputation: 8874

No, there is not a button to do that. However, you can concatenate the two columns to third column and use that instead.

Upvotes: 3

Related Questions