How to transpose rows to columns using ETL
I have a large dataset that has thousands of rows, most of those rows have the same value for most columns except for one. I'm trying to transpose the value from the rows that are in one column to multiple separate columns, removing the duplicate lines. I know the "Pivot" function in ETL is what i need to use, but i'm stuck because it is not very on how to use the function.
Any help is appreciated!