Hello everyone, I hope someone can help me and I've been looking for how to transform columns into rows and find their registry when it has been modified, filtered by date range and the truth is that it has not been much, and searched and looked at but I definitely do not find it, an example of what I'm looking for ... if someone can help me or guide me ...
columna 1|columna 2|columna 3|fecha
valor 1 | valor 1 | valor 1 |18-10-2018
valor 2 | valor 2 | valor 2 |19-10-2018
and what I want to achieve is:
parametro |valor anterior|valor nuevo|fecha de modificación
parametro 1| valor 1 | valor 2 | 19-10-2018
parametro 2| valor 1 | valor 2 | 19-10-2018
parametro 3| valor 1 | valor 2 | 19-10-2018
I hope and you can guide me ..... Thanks.