transpose column date value to r

hana sql,transpose column date value to row - Stack Overflow
I have a table as below and date value are over the year.DATEWEEKBRANDVALUE2024-04-01Mondayabc100
hana sqltranspose column date value to rowStack Overflow
admin4小时前
60