Combine two column's into single column

Question

Hi All,&nbsp;i want to combine two columns into single columns&nbsp;&nbsp;Example :&nbsp;emp1&nbsp; &nbsp; emp2&nbsp; Worktype&nbsp; status salary300&nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||301&nbsp; &nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||302&nbsp; &nbsp; &nbsp; &nbsp;102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||303&nbsp; &nbsp; &nbsp; &nbsp;103&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp;Ouput:EmpId300301302303100101102102&nbsp;So i need to combine only emp1 &amp; emp 2 columns only&nbsp;&nbsp;I tried append quries but the data coming all&nbsp;&nbsp;Any one idea on this please...

aliensx · Answer

Hi,&nbsp;MAruna&nbsp;Table.FromColumns({Source[emp1] &amp; Source[emp2]}, {"EmplId"})

Forum Discussion

Combine two column's into single column

1 Reply

Related content

Combine Column

Combining Column Data

Autoexist in single column??

Combine columns into 1

Tables combine