Hey!
I am trying to dynamically create new columns based on user input. I have one excel sheet which has all the column names I will need to have. The ACTIVITY DESCRIPTION will be the new column Names, and the ACTIVITY TYPE will be the value.
My Input one is the data I want to add these columns to.
My final Output looks like this.
The key thing to mention here is that the data joins at different rows. I have tried using Crosstab on input 2 to make it into columns. But i cannot figure out how to join the data at different rows. Any help would be much appreciated. Attached it is the excel file.
Solved! Go to Solution.
Hi @backrocket
Here's a workflow that does what you're looking for. It uses 2 transposes to build the 2 header rows. It joins the 2nd header row to the main data and unions all the resulting rows. The trick I used here is to start the recordID for the main data at 2 so that it would match up with the second header row.
Dan