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