How to move columns as rows when they are merged

I’ve been struggling with this problem with no solution in sight. I’m trying to move the column names as rows under a new column ‘Date’ and use ‘current’ and ‘year ago’ as my new columns. I tried using both unpivot and transpose with no luck. attached is a screenshot of my current table along with the desired table.