Collapse / Uncollapse Columns
I've been attempting to use the uncollapse columns feature to flip the dimensions of my dataset that has only 2 columns. I think I have been filling out the drop down boxes correctly, except maybe the second requirement: selecting columns that identify a row. Here is an attached example of what I need to flip. I want to have the contents of one column as the new, row values, and the other column in the originial dataset needs to be the column labels / headers. I have tried using pivot in the SQL transform but haven't been able to construct the result that way either. Any help is appreciated.