May 17 2020 03:51 PM
Hi, I have a pivot table which shows data from 2 adjacent cells (in 2 rows) when I want the data from one row at a time. Basically I values in my pivot table according to data in rows and the problem is that for some of the values the data in two successive rows are added.
In the screenshot, I have the data I want for 0.4% and 0.6% but I have two values for .7% which is my problem.
Thank you in advance for the help.
May 17 2020 09:26 PM
Can you share the data set. Must be 2 entries corresponding for 0.7%.