you have column A with multiple values separated by comas and some values appear more than once in a cell. How can you copy column A into column B without duplicate values . For example. in column A: A1 = a, b A2 = A3 = c, b, c A4 = a, b, b,c,a A5 = d Column B would be: B1 = a, b B2 = B3 = c, b B4 = a, b, c B5 = d Please provide examples.
... View more
Please help with this how can you transfer data from situation 1 to situation 2? data situation 1: column A : A1 = 1 ; A2 = 2 ; A3=3 column B : B1 = 11 ; B2 = 12 ; B3 = 13 column C : C1 = allo , okay ; C2 = ; C3 = z , d , h data situation 2: column A : A1 = 1; A2 = 1; A3 = 2; A4 = 3; A5 = 3; A6 = 3 column B : B1 = 11; B2 = 11; B3 = 12; B4 = 13; B5 = 13; B6 = 13 column C : C1 = allo; C2 = okay; C3 = ; C4 = z ; C5 = d; B6 = h note that C2 is when situation 1 is empty and C3 is when situation 2 is empty so data input is situation 1 and data output is situation 2
... View more