Losing Unique Values When Doing Table Split
I have a table set up like the following. I want to split the Service column by Type so that the result looks like the second table below. However, when I do this, I end up losing a lot of unique values of ID. For reference I have 15,047 unique IDs and 78,276 rows in my raw data table. Of these 78,276 services, only 963 are Type2. When I do the table split, the result gives me a table of 77,313 ro...