Error Message

[LearningBI1986]

Hi guys,

I want to merge two columns together. I have two columns - an eticket number, and a regular ticket number. It seems the data is presented such that if there is no eticket number, then there is a regular ticket number. 

I would like to have just one column with all ticket numbers.

Any suggestions would help!

Thanks!

[AbhinavJoshi]

Hello @LearningBI1986 . You can merge two columns in two ways. Go to Power Query Editor -> Select the two columns that you want to merge, right click and merge columns. 

Make sure your columns are of the same time, I would highly reccomend to make them text type.

Another option is to write a custom column. Go to Add Column -> Custom Column and write a formula. Here's one example [eTicket] & " " & [RegularTicket]. This formula concates them and seperates them through a space. I hope it helps!