Forum Discussion

geeklarokcmie's avatar
geeklarokcmie
Helper III
2 years ago
Solved

Convert Columns to Row based on the date

Hello experts:

 

I'd like the convert the below name columns into rows based on the date. 

 

Here is the input: 

DateName_1Name_2Name_3
04/01/2024Apple_1mpMeta_trxw1MS_appw1
04/01/2024Apple_2mpMeta_trxw2MS_appw2

 

Expected Output:

DateNames
04/01/2024Apple_1mp
04/01/2024Meta_trxw1
04/01/2024MS_appw1
04/02/2024Apple_2mp
04/02/2024Meta_trxw2
04/02/2024MS_appw2

 

Need Help

1 Reply