Data-Transform-Delete-Rows

Excel
> Click into Data Table
  Data > Queries & Connections > Double-click
  [Power Query Editor]
  > Query Settings > Applied Steps
  > Right Click any Column > Remove Duplicates
  > See that information is lost
  > Undo the last step