@domjammoo point well taken. Crosstab format with no aggregation is EXACTLY what I was hoping to accomplish.
My use case is simply trying to plan out hours by person by project by month. Displaying the data as you would store it in a database is NOT visually user friendly. This is where that crosstab functionality would do the trick. I was dynamically pivoting the table in Oracle and displaying it in a Retool table which visually works but you can't edit it because the columns are dynamic. You can't programmatically set the column as editable in Retool so it's display only. I dunno, every way I spin this I run into some roadblock and the majority of them are in Retool... #frustrating. 
If this was just one project with one performance period it would be easy. Of course, it's not, it's hundreds of projects with multiple performance periods.
Oh well, thank you for helping me figure out I don't want a pivottable 