Sep 02 2021 06:10 AM
There seems to be a different response when setting up a table. E.g. Data in four columns- should this be one table, OR, should each column be its own table? Does it make a difference when using formulas on the individual columns? Different formulae of course have different data needs, so is there a "better solution" that can cover most contingencies? Thanks.
Sep 02 2021 06:19 AM
SolutionDo the data in one row "belong" together, for example first name, last name, date of birth and place of birth of a person? If so, you should create one table - you want the data to stay together in the same row.
Or are the data not related to each other, and could one column have more or fewer rows than another column? In that case, it's better to create separate tables, so that each can be manipulated independently from the others.
Sep 02 2021 06:51 AM
Sep 05 2021 12:39 AM
Sep 08 2021 11:28 PM
Sep 02 2021 06:19 AM
SolutionDo the data in one row "belong" together, for example first name, last name, date of birth and place of birth of a person? If so, you should create one table - you want the data to stay together in the same row.
Or are the data not related to each other, and could one column have more or fewer rows than another column? In that case, it's better to create separate tables, so that each can be manipulated independently from the others.