Add rows to a column based on other columns

[XaviOV]

Hello

When I import an Excel database, which contains multiple columns, I would like to know how you could add the header title of a column to multiple rows in a column

Best regards

Xavi

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[XaviOV]

Hello @amitchandak apologies for the lack of additional information.
What I would like to do is that the data that appears in the "User" column transfer them to the "Answers" column, and the word "User" was in the "Question" column, the ID column has different values and groups the questions.

Greetings and thanks in advance.

[v-eachen-msft]

Hi @XaviOV ,

What I would like to do is that the data that appears in the "User" column transfer them to the "Answers" column

Do you mean to combine these two columns or not? For better understanding, you could show your expected results whose ID in Excel is AAATCAAD and show it here.

[XaviOV]

Hello, @v-eachen-msft @amitchandak 

What I really want is to combine those two columns so that the "Name" field appears once for each ID.
Attachment captures the Excel file for a better understanding, if you need more contributions do not hesitate to ask me.

Before:

After:

Regards,

Xavi

[v-eachen-msft]

Hi @XaviOV ,

It is difficult to achieve your needs with DAX, I recommend that you could do it in query editor.

Unpivot "Usuario" column and append with orginal table as a new table.

[XaviOV]

Hello @amitchandak @v-eachen-msft

What I want is to effectively combine those two columns so that the "Name" field for each ID appears once.

Attached capture of Excel file for greater understanding, if you need more input do not hesitate to ask me.

Best regards

Xavi

Before:

After:

[Ashish_Mathur]

Hi,

Your data and question are just not clear.  Paste data in the body of the message and show the expected result clearly.

[XaviOV · Accepted solution]

Hi all, @Ashish_Mathur @v-eachen-msft @amitchandak 

The problem is resolved, in Power Query Editor I did "Append Queries New" and resolved it 🙂

Regards for the answers!!

Xavi

[XaviOV]

Hello @amitchandak

The Report tab, I have an array where in Columns the data of the Column "Question" is and I would like to add "User found in the other column.
In Rows is the ID column and in Values I have the data for each "Question.

Greetings and thanks!

Example of how I'd like to see it.