Viewing entries in
data cleaning

How to merge and tidy data with Excel

1 Comment

How to merge and tidy data with Excel

The VLOOKUP function is a straightforward way to merge data in Excel. I use it daily to combine two different dataset when a simply copy and paste just won't do. The most common reason for that is different numbers of rows (entries) between the two datasets we're working to combine. For example one dataset might be a list of people and their job title, the other might be a list of phone calls, with the same person dialled more than once. In that case we could use VLOOKUP to append the list of phone calls with the job title of everyone who is called.

1 Comment