Forum Discussion
Helper VAdd rows to a column based on other columns
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
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
9 Replies
- amitchandak
Super User
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
XaviOVHello @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.- 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.
