How do I get two values in one cell?

To effectively represent individuals with multiple occupations in your data table, you can combine the occupations into one cell using a straightforward approach. This method allows you to maintain clarity while ensuring that each occupation is represented in your pie chart. By separating the occupations with a delimiter—such as a comma or a slash—you can keep the data organized and visually distinct. This way, your chart will accurately reflect the diverse roles of each individual without creating separate entries for their combined occupations.