Formula1, Formula2 appearing as row items in pivot table where row labels previously were

I was greeted by a spreadsheet that my wife was using that she had messed up. A table than previously showed date, time, address and hours , was now replaced by date, time, formula1, formula2....formula7 as the values in a column and then the duration.

this was solved by going to pivot table Analyse, Fields, items & sets, solve order and deleting the formulas from there. then the addresses reappeared in the pivot table when it was refreshed

So I have no urgent need for a solution, but I am curious if anyone can shed light onto how she could have created this in the first place. she would not be deliberately changing anything, he involvement usually consists of cutting and pasting data to a table and pressing refresh on a pivot table. I suspect some random keystrokes?

Ideally I want to prevent this occurring again in the future, so I do not have to fix it at 2am in the morning! This was office 2016 if that helps

As I fixed the spreadsheet and saved, I do not have a workbook in this state to post (it was late)

Any insight appreciated.

I found the answer myself. So the following link explains how the problem is created

https://www.pivot-table.com/2014/02/...culated-items/

if you select a row item and go to the botttom right of the cell to the black cross hairs and drag down, it inserts formula1, formula2 formula3 depend how far you dragged it, and the appear in multiple cells in the pivot table.

The solution is as listed above

Going to pivot table, Analyse, Fields, items & sets, solve order and deleting the formulas from there. then the addresses reappeared in the pivot table when it was refreshed