Let's say I have data in a table with columnames of key, col1, col2, col3. Note name of first column is key in this example- could be anything. Can I have this data converted into a table having these columns - key, colname, colvalue.
Key, col1, col2, col3
Is this kind of a Transposition possible?