A normal report output has distinct fields with distinct headings
In Pivot reports the fields concatenate with a '|' symbol separator.
When these are exported to Excel they will occupy one cell
If you need to Split these into two or more cells you can use the Excel functtion TEXTSPLIT().
First you need to open a space for the split fields to occupy and then you enter in the first field =TEXTSPLIT(<Cell>,'|')