I'm having trouble getting alteryx to flip my data in the correct way. When I apply the transform method, the end result looks way more like I used the "melt" command in R or something than it does a true transposition. Further, I also need to combine the duplicate columns where possible, but I'm not really sure how to do that. I have no control over how this excel sheet is given to me, by the way, so I'm fairly well stuck with the format.
I've attached a mockup of how it comes to me. You'll notice the green-text entries are columns, I need those to be the rows. But also, note that the current rows are repeating, stuff like "amortization" appears multiple times. Those all need to be combined. I have on the second sheet attached how it should wind up looking. Thus far, I have tried using the cross-tab and transpose tools in alteryx, but they... have failed, like I said. I'm not sure how to get the data to look like what I want it to.
