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.
Hi Detlef and thank you for the response. Yes, there is indeed no issue with deleting the rows but as stated this is dumbed down data and in my "real" data set I can not delete any rows.
Let me know if that changes something.
Let me know if that changes something.
It is not clear to me. Please specify whether you are not able to delete rows (action throws an error or nothing happens) or your are not allowed to delete rows (boss says so),.
- Detlef...greetings.
To answer your question, I do not have any issues deleting the rows. I can do this HOWEVER I can not delete any rows in my data set since my production data set will not allow that. I do not see how to create a pivot with the data as provided. Let me know if not clear still.I still do not comprehend. However as I pointed out before the main obstacle is the crosstabular format.
- got it. LIttle surprised that excel can not handle a pivot of crosstabular format. darn. OK thank you for the help.