Pivot information – sql table

I was wondering if someone could help me swing the data in sql? I'm a newbie and I need help

I want to pivot data based on the "LastLogOn" column. Is it possible to do it in SQL?

Since:

enter the description of the image here

TO:
enter the description of the image here