Hi,
I need to transpose the data. I have a promotion that is running from 6/28/2020 to 07/26/2020. First I needed to convert those weeks to weeks that the first day of the week is Sunday, which I did, so now the promotion is running from 7/5/2020 to 7/19/2020. Now, I need to take that one row and change to three separate rows with the same attributes, but that will show me each week on the separate line: 7/5/2020, 7/12/2020 and 7/19/2020. I attached current view and desire output. Does anyone know how to do it?
