I'm thinking of doing a View for report development, and I ran into the following problem.
I would like to merge the columns PUBLIC1, PUBLIC2, PUBLIC3, PUBLIC4 into a single column.
Eg: AM0173 would have 2 lines
ID_3_ETAPA | PUBLIC
AM0173 | 2
AM0173 | 1
Can I do this on a select?