Chinwendu Alokalam
Reputation: 1
Data Cleaning using Ms Excel
How do I convert this dataset to this clean one using Excel
I tried using Xlookup, but it seems that's not the correct formula to use because it didn't yield any positive result and I don't really understand the INDEX MATCH formula because I'm still new to it
Upvotes: 0
Views: 25
Answers (0)
Related Questions
- How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
- How can I avoid using Select in Excel VBA?
- How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
- Return empty cell from formula in Excel
- Advanced Excel Help - Lookup Formula
- How do I properly clean up Excel interop objects?
- xlookup formula with more than one criteria
- Excel function for two columns