How do we combine data from two columns into one? I’m gonna show you guys two easy ways. Let’s check this out.

There are names from two columns A and B, now we need to combine these names into column E.

No.1 Powerful Equal Sign

No.2 Pivot Table

Select the data area and go to the insert tab to choose the Pivot Table.