I have a spreadsheet with thousands of lines but I will just show one line because each row is independent.
For the life of me I cannot figure out how to format the example in this message space, so I put a public link to a Google Sheet, but I am using EXCEL for the actual spreadsheet not Google.
If this is not OK can someone point me to directions on how to post data cell examples?
https://docs.google.com/spreadsheets/d/1t8hdGEEkuR8C_hJs-IPY4HcmlNokqKCaE2TJLMpd-TQ/edit?usp=sharing
You can see Treatment is there twice (A1 and G1) so I want to output B1 and H1 into L1 separated by space semicolon space " ; "
Supplement Line is only there once (C1) so I don't need to combine it with anything, I just need D1 to output into M1
Aesthetics is also there twice (E1 and I1) so I want to output F1 and J1 respectively into N1 also separated the same way " ; "
I have 19 different categories that would be in green.
Thanks so much everyone.
For the life of me I cannot figure out how to format the example in this message space, so I put a public link to a Google Sheet, but I am using EXCEL for the actual spreadsheet not Google.
If this is not OK can someone point me to directions on how to post data cell examples?
https://docs.google.com/spreadsheets/d/1t8hdGEEkuR8C_hJs-IPY4HcmlNokqKCaE2TJLMpd-TQ/edit?usp=sharing
You can see Treatment is there twice (A1 and G1) so I want to output B1 and H1 into L1 separated by space semicolon space " ; "
Supplement Line is only there once (C1) so I don't need to combine it with anything, I just need D1 to output into M1
Aesthetics is also there twice (E1 and I1) so I want to output F1 and J1 respectively into N1 also separated the same way " ; "
I have 19 different categories that would be in green.
Thanks so much everyone.