Forum Discussion

ealiisl's avatar
ealiisl
New Member
1 year ago

How to make Lists from Date column.

I have a one column with dates from year 2021 to year 2024. From this, how can i make seprate columns for each year. 
SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
1 year ago

Hi ealiisl 
What does the data look like?

If something like this you can tell the data to pivot.

 

  • ealiisl's avatar
    ealiisl
    New Member
    1 year ago

    Hello Sam:

    unfortunately not like this. i dont want to count the occurances. I want each year in seprate column because every cell has different date.