- last edited on
Hello, I am new in Power Query and I want to structure the following original data as a time series structure (I need to leave the values that do not have information in blank).
Goal (time series)
View best response
You may pivot on names - value first table and merge it with second one using right outer join.
I assume months are defined in same way for both tables, here are as first date of each month - please see attached