Hello,
I'm trying to Concat only uniques values from column K, however since the values in column K are the combination of values in columns F-I I'd like to concat these as well. For example if Cell K2 is a unique value then I'd like to concat this value to sheet 2 along with the values of cloumns F2-I2 which are the vlues that make the overall value of K2. Below is minisheet to reference.
Thanks,
I'm trying to Concat only uniques values from column K, however since the values in column K are the combination of values in columns F-I I'd like to concat these as well. For example if Cell K2 is a unique value then I'd like to concat this value to sheet 2 along with the values of cloumns F2-I2 which are the vlues that make the overall value of K2. Below is minisheet to reference.
Thanks,
New GUI.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
F | G | H | I | J | K | |||
1 | Material | Series | Surface | Width | IN/MM | Chain Desc | ||
2 | HP | 8500 | 6 | 24 | IN | HP8506-24IN | ||
3 | HP | 8500 | 5 | 18 | IN | HP8505-18IN | ||
4 | HP | 7700 | 5 | 24 | IN | HP7705-24IN | ||
5 | HP | 1500 | 5 | 24 | IN | HP1505-24IN | ||
6 | HP | 8500 | 5 | 18 | IN | HP8505-18IN | ||
7 | HP | 7700 | 5 | 24 | IN | HP7705-24IN | ||
8 | HP | 1500 | 5 | 24 | IN | HP1505-24IN | ||
form |