I'm completely new in Zoho and SQL and have just started playing around with some data that I'm working on for analysis.

What I need to do is that I have data in multiple columns (numeric values) that I'd like re-shape the data in this manner.

1) Merge data from multiple columns into data in a single column (as variable column)

2) Create separate column for variable type (the original column names will become the variable type in a new column

This can be done very easily in R script using "melt" function but I'm not sure how to do it from Zoho Creator. Can anyone help with it?

Thanks in advance.