Split one column to 2 columns and reduce number of duplicate rows
I have a set of data with both unique and repeating SalesIDs. On the the second column, is an identifier "1" or "0". Some sales Ids have both 1 and 0 but some have only 1 or 0. I want to have these data set in qlikview such that I have a single comlumn of unique SalesIDs and 2 new columns have "True" and "False" where each row could have a value either in both or only in 1. This way the duplication would be gotten rid from my data.