HEADER COLUMN DINAMIC

[sahernandez]

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.

[d_gosbell · Accepted solution]

Unpivot columns

[sahernandez]

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.

[d_gosbell]

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.

[sahernandez]

What operation I need to do that?