Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to solve two dates with the same Status Name

Hi Newbie here,    I have this data and i want to pivot the Status to become the column and the status start date as their values however there are status that has two dates. How do I solve this so...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

wdx223_Daniel ,Hi - Thank you but it seems did not work, it captured the older dates 
Pivoted


Original

ronrsnfld's avatar
ronrsnfld
Super User
3 years ago

You wrote you wanted the earlier date.  Isn't the the same as the older date?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    ronrsnfld Sorry for the confusion. I want to get the earlier date not the latest date.