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.
How to approach?
any assistance is appreciated.
thank you
Power Query is an option for such tasks.
9 Replies
I have no problem deleting rows 2 and 3.
Apart from that your data is not suitable for pivot table because it is already in a crosstabular format.
- 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.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),.
