How do I merge different columns in the same table?

Question

Hello everyone. I would like help and to know if it is possible in something that I am having difficulty in Power Query.&nbsp;I have a table where in different columns it has the Registration Indicator. But I would like to join these columns into one. That is, do a merge from a reference column, which is the Ad ID.&nbsp;Where in one line of the specific ID it has for example:&nbsp;Column A: 2 registrationsColumn B: 2 entriesColumn C: 0 entries&nbsp;It returns me in column D 4 entries.&nbsp;In short, what I want to do is equal to the Query Merge, but in the same table, using columns, instead of doing it between 2 tables.&nbsp;Does anyone know how to help me with this?&nbsp;Below is an example image of the columns that I want to merge.&nbsp;

imkef · Answer

Hello&nbsp;matheus_peppers&nbsp;,if my understanding is correct, you can merge them like so:check all 3 columns -&gt; Add column -&gt; Merge columns:

&nbsp;

Forum Discussion

Related content

1. How to add two different calculated columns of two different table

How to add two different calculated columns of two different table

Date difference between two different tables columns

Create a Column where sum two columns from different tables

Compare two columns in different tables