Changing table values to headers

[Anonymous]

Hi,

I have a set of data that looks like the below;

ConfirmationId	Answers.Questions.QuestionName	Answers.TextAnswer
330478	BOOKING REQUEST DATE	17.01.20
330478	CANDIDATE EMAIL (NC)	test@GMAIL.COM
330478	INVOICE TO mandatory	CANDIDATE TO POD
330478	COST CODE	NA
330478	etc....	etc.....

I want the data to look like this below;

ConfirmationId	BOOKING REQUEST DATE	CANDIDATE EMAIL (NC)	INVOICE TO mandatory	COST CODE	etc....
330478	17.01.20	test@GMAIL.COM	CANDIDATE TO POD	NA	etc....

I need this to work for as many column names that are listed in the first table (which is more than what I've shown).

[amitchandak]

Refer, this can help

https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous]

Thanks for the quick reply.  I did try to pivot the column but I don't have numbers in the values column it is text data.

[Anonymous · Accepted solution]

Fortunately for you, this will still work, even on text 🙂

Just select your second and third column. Then do pivot, in advanced options choose MAX instead of COUNT and in your "values" column use your Answers.textanswer column.

Tadaaa 🙂

Jaap

[Anonymous]

Perfect!

Thankyou all.