If you want to analyze or manipulate data, you have to save it in a format that you can easily retrieve. So I want to go over a few best practices for saving data so that it can effectively be used in the future.
Don’t include multiple pieces of data in the same cell.
There are many reasons you might do this, like having multiple keywords that are relevant to a particular page. But it will make the data super difficult to sort, compare and understand in any other way besides by a human.
Do create a new sheet or table (if you’re talking Access) for each type of data.
When dealing with data where multiple data fields have more than one relationship to another field (ie: each URL and each Keyword have multiple relationships to the other), the ideal way to save this information is actually in three different tables—one for each field, and another to define relationships.