ColemenWilson Coach 
-
Re: Best Practice - Columns to Rows?
You can use the Dynamic Unpivot tile in Magic ETL: Results:2 -
Re: beast mode
I've re-read this like 10 times and can't figure out exactly what you are trying to do. Could you share once again slightly differently? Or maybe show two excel samples: what the data currently looks…2 -
Re: beast mode
I understand now, thank you! Yes you will want to do what @ggenovese recommended.1 -
Re: Overlapping Date Beast Mode
I approached this using Magic ETL, and here is how I did it: 1. Create a Lead and Lag function to get the previous End Date and the upcoming Start Date. 2. Create a formula to flag when there is over…1 -
Re: Text column as values in Pivot table.
I'm not sure I am completely understanding what you are trying to do. Could you create a table in a spreadsheet as an example?1
