What is the use of a Pivot table? Also explain the KNN imputation method, in brief

One of Excel’s most useful features is pivot tables. They make it straightforward for a user to see and summarise huge datasets in their entirety. The majority of Pivot table actions are drag-and-drop procedures that help in the rapid production of reports.

KNN is a technique that needs simultaneously selecting a number of nearest neighbours and a distance measure. It is capable of predicting both discrete and continuous dataset characteristics.
The similarity of two or more qualities is determined using a distance function, which will aid in further analysis.