New answers tagged worksheet-function
First, I'd split the data from column A into two columns. In this case it looks like the length is consistent so it makes it easier (I can demo the other if need be). Get the left chunk with =left(A2,11) Get the right chunk with =right(A2,10) Now you have Element 1: | Value 1.1 To flip the unique elements use =transpose(unique(B2:B7)) Now you have ...
Top 50 recent answers are included