Dynamically inseart new columns from new Data

Question

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.

Sample data.xlsx

danilang · Accepted Answer

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