star wars kotor 2 how to use work bench formulas

To create the top left table, put Persona into the Rows field and then put App into Rows field as well. Look up PivotTables and PivotCharts for more info. It's also possible to easily count the number of apps in each persona and vice versa and then also create charts. With your data set up correctly, you can now create PivotTables that automatically arrange your data either way. It doesn't matter in what order you place the data. Then on every row, you list just one possible combination of Persona and App. See this article for more info:įor your data, you should just have 2 columns, one for Persona and one for App. If you want to perform analysis, data should always be stored in a database format. The layout of your data is good for viewing, but is not suitable for any kind of data analysis. However, trying to rearrange your data with either formulas or VBA would take a lot of time and effort and is also quite unnecessary. I can't figure out any way to do this an insane nested statement, VBA, or a similarly crazy array formula. Row App Persona 1 Persona 2 Persona 3ġ Slot Kings 'Casino Persona' 'Slot Persona'Ģ KOTOR 'RPG Persona' 'Star Wars Fans' 'SciFi Persona'ģ MLB: The App 'Sports Persona' 'Baseball Fans' I'd like to create another worksheet that switches 'apps' and 'personas.' e.g. I'm now trying to determine which personas belong to each app. So i know which apps belong to each persona. Row Persona App 1 App 2 App 3ġ Casino Persona 'Slot Kings' 'Wild Casino' 'Real Gambling App'ģ Sports Persona 'MLB: The App' 'Real Soccer' 'Hockey Fans 2016'Ĥ Gen-X Females 'Scrapbook App' 'Baby Monitor' 'PostMates'

Each persona has a different number of apps.

I have the data organized by persona: each row is a persona, and each column in that row contains one of the apps comprising that persona. A persona has many apps, and apps have many personas. We run 'personas', which is a group of apps. I'm a programmatic advertising data analyst, so i'm trying to associate a many-to-many relationship. I've seen some similar posts, but none with a really helpful answer for my particular issue.

Star wars kotor 2 how to use work bench formulas