Retrieving the Column Header that Corresponds with a Matched Value

Question

Hello,&nbsp;I need to create a Quality Check reports, which is showing different error messages related to incidents. It should look like the following: (behind every QAx column, we will have different calculations, which will give back a true or false value, like: if the created date is higher than the closed date, then the QA1 should true.)TICKET_IDQA1QA2QA3QA4QA5QA61TRUE&nbsp;&nbsp;&nbsp;TRUE&nbsp;2&nbsp;TRUE&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;TRUE&nbsp;&nbsp;&nbsp;4&nbsp;&nbsp;&nbsp;TRUE&nbsp;&nbsp;5&nbsp;&nbsp;&nbsp;&nbsp;TRUE&nbsp;6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TRUEI would like to create a new column (ERROR_CODE) which will list every QA code where the ticket has TRUE value.&nbsp;TICKET_IDQA1QA2QA3QA4QA5QA6ERRORERROR_CODE1TRUE&nbsp;&nbsp;&nbsp;TRUE&nbsp;TRUEQA1,QA52&nbsp;TRUE&nbsp;&nbsp;&nbsp;&nbsp;TRUEQA23&nbsp;&nbsp;TRUE&nbsp;&nbsp;&nbsp;TRUEQA34&nbsp;&nbsp;&nbsp;TRUE&nbsp;&nbsp;TRUEQA45&nbsp;&nbsp;&nbsp;&nbsp;TRUE&nbsp;TRUEQA56&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FALSE&nbsp;7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TRUETRUEQA7Can somebody help me out with this?Thanks and regards,Daniel

anonymous · Accepted Answer

Hi&nbsp;DanielRatvai&nbsp;,
&nbsp;
Agree with&nbsp;lbendlin&nbsp;. In Power Query, you can use unpivot columns and Text.Combine() to achieve it.
Reference:
Unpivot columns - Power Query | Microsoft Learn
excel - PowerQuery/M: How can I combine text from multiple rows into one row - Stack Overflow
&nbsp;
&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Retrieving the Column Header that Corresponds with a Matched Value

2 Replies

Related content

Retrieving data via HTML

Cannot retrieve Contacts from API

Retrieving deleted notebook

Sumif of multiple corresponding values

Retrieving Values from Single Column

TICKET_ID	QA1	QA2	QA3	QA4	QA5	QA6
1	TRUE				TRUE
2		TRUE
3			TRUE
4				TRUE
5					TRUE
6
7						TRUE

TICKET_ID	QA1	QA2	QA3	QA4	QA5	QA6	ERROR	ERROR_CODE
1	TRUE				TRUE		TRUE	QA1,QA5
2		TRUE					TRUE	QA2
3			TRUE				TRUE	QA3
4				TRUE			TRUE	QA4
5					TRUE		TRUE	QA5
6							FALSE
7						TRUE	TRUE	QA7