A handy little tip from the Paste options in Excel Copy then Paste and select the Transpose option. It doesn't work if you Cut - only Copy and not next door - select a cell underneath or on a new sheet.

Managing duplicates in Excel can often be a daunting task, but with a few simple steps, you can easily identify, filter, and remove them to ensure your data is as accurate and clean as possible.

Click the Search bar to activate it - and from there use Advanced Search features to drill down to the required dates.