Hi,
I must convert data from a calendar type view to a list, it’s a tedious and highly frequent task.
If there are few data… I do it manually. If not, I combine in a single column the content of the three “non calendar” columns and I create a pivot table so that dates are the columns and a single row label contains the descriptions. When I click in the totals cell, I obtain a new tab displaying a list and I separate again the content of the combined column.
I wonder if there is a more agile alternative. At home I could try to learn the possibilities of PowerBi in the new versions of Excel but this is not the case at my work. We use an old, old version.
Any possibilities of using a formula or a more intelligent approach?
I really appreciate any help you can provide.
Thanks in advance.
I must convert data from a calendar type view to a list, it’s a tedious and highly frequent task.
If there are few data… I do it manually. If not, I combine in a single column the content of the three “non calendar” columns and I create a pivot table so that dates are the columns and a single row label contains the descriptions. When I click in the totals cell, I obtain a new tab displaying a list and I separate again the content of the combined column.
I wonder if there is a more agile alternative. At home I could try to learn the possibilities of PowerBi in the new versions of Excel but this is not the case at my work. We use an old, old version.
Any possibilities of using a formula or a more intelligent approach?
I really appreciate any help you can provide.
Thanks in advance.