Bringing field header into output

[JGalle0121]

Please see attached Alteryx workflow output thus far.  What I am trying to do is assemble a list of necessary projects to track - that would be the combined column header + deliverable type for any line where the total hours exceeds 0.

Example output for the column with the header Project_1:

Project_1_Deliverable Type_1

Project_1_Deliverable Type_3

Project_1_Deliverable Type_6

I have multiple projects in columns with hours by deliverable type across in rows.  I'd like the end result to be a single list that shows the concatenated Project & Deliverable Name combined for any project with hours >0.

I was originally going down the path of individual formulas for each column, but there has to be a better way.

Thanks in advance!

[LordNeilLord · Accepted solution]

Hey @JGalle0121

Transpose tool is your friend here :)

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[JGalle0121]

Thank you both!  I confess I'm so used to my data being in columns that I hardly use Transpose - now I'm thinking, duh.  Sometimes you just need another pair of eyes.  Gave you both stars, have a great day!