Forum Discussion
Solved
HEADER COLUMN DINAMIC
Hi,
I have a table like this.
I need to extract the information searching by name and return the result depending on the date. For example if I filter by "1PERSON" and 03/01/2023 date, the inform have to return me PLACE2. Is it possible to do that?
Thank you.
Unpivot columns
4 Replies
It would usually be easier to perform an unpivot operation on data like that so that you had 3 columns: Name, Date, Place
Then it becomes simple to filter by the name and date columns.
What operation I need to do that?
Unpivot columns
In the end I achieved it with part of your proposed solution.
First I clicked on the transpose option. I did the first row of headers and then pivot table.
Thank you so much.
