- Below is the raw data file
- I am using Parabola pivot to move CRSD dates into new columns.
a) As you see on the screenshot below, the first PN, 38950-00901-101, is shown as two separate rows with values under 12/14/2020 and 12/15/2020 columns. Shouldn’t this be shown in a single row?
b) Assuming I can fix question a), can I then group these new columns by month like in Excel? I have already converted the format to date in an earlier step.
Thank you for your help