Apr 28 2021 06:45 PM
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
Apr 28 2021 09:36 PM
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.
Apr 29 2021 07:41 PM
Apr 29 2021 11:27 PM
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),.
Apr 30 2021 03:05 PM
Apr 30 2021 03:18 PM
I still do not comprehend. However as I pointed out before the main obstacle is the crosstabular format.
Apr 30 2021 07:22 PM
May 01 2021 10:04 AM
SolutionPower Query is an option for such tasks.
May 13 2021 01:59 PM
May 15 2021 03:23 AM
Glad it helped. Unpivoting is quite standard and often use operation to normalize tables in data model.
May 01 2021 10:04 AM
Solution