I would like to know if its possible to use pivot tables other than for calculations.
I have a table that stores record like
item 1 level 1
item 1 level 2
item 1 level 3
I would like to display it as follows
item 1 level 1 level 2 level 3
Now i have to export the data and do it in excel but would be nice for the user to be able to do it with in tadabase. if there are external tool like Make that I can use for this i’m open to that as well.
Thank you