Transpose a table?
I need to transpose a table just like one can transpose a table in Excel.
I want to transpose from this
to this
Any ideas?
I need to transpose a table just like one can transpose a table in Excel.
I want to transpose from this
to this
Any ideas?
Comments
3 comments
You would have to use the UnCrosstab Filter on the datalayer and then a Crosstab Filter.
You will need to do a bit of finessing in order to get the Months column in the correct calendar order since at this point the values are just string values, but this will get you close to a solution.
Thank you!
Please sign in to leave a comment.