Hi, i have 2 SQL imports in Powerpivot from the same source, one is the Total_Data, the other is the customer id limited by SQL script to the Unique_value.
I have made a relation between Total_Data and Unique_value so far so good.
Now the challenge is that in the Total_Data is a column which is called Questionaire where all questions are answered from the 5 questions ranged from Question 1-5.
Now i want to create a new column in Unique_Value where each column is Question 1, Question 2 etc, so changing data structure in Questions from rows to columns.
I have tried with IF to no avail.
I have made a relation between Total_Data and Unique_value so far so good.
Now the challenge is that in the Total_Data is a column which is called Questionaire where all questions are answered from the 5 questions ranged from Question 1-5.
Now i want to create a new column in Unique_Value where each column is Question 1, Question 2 etc, so changing data structure in Questions from rows to columns.
I have tried with IF to no avail.
