Forum Discussion
Solved
Pivot - non contiguous dates
Hello, I am trying to make a pivot out of the attached. The data is dumbed down for ease and my my real data set is much larger and there are many rows with blanks. I can not delete the row. ...
Power Query is an option for such tasks.
got it. LIttle surprised that excel can not handle a pivot of crosstabular format. darn. OK thank you for the help.
Power Query is an option for such tasks.
Glad it helped. Unpivoting is quite standard and often use operation to normalize tables in data model.
- this is exactly what I used. Worked well. Must unpivot which is a little odd to me.