I am trying to create single columns from multiple columns in Spotfire and can’t quite get it right. Currently my data is in this format (I have a column for each item I would prefer to have as a row based on the subject):
Current table format
I would like to transform it to this:
table format I would like
Any help greatly appreciated!
I have only tried pivoting but this has not worked.
New contributor
Magda Dolena is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.