Svmaxcel
12-16-2017, 08:12 AM
I am joining some text based on some conditions.
File Attached.
Col b has the scores, If target is met Col C shows Met or Not Met.
Col D will then display the comments based on Col C (Met/Not Met) and Col A(Parameters).
Till here everything is fine.
Row 12,13 has Strength and Focus, so all Parameters which are met should come in Strength and Not Met in Focus.
Now the final part (Overall Comments).
I want all Parameters and Comments to join together and every Parameter should start on a new line as they all come in one lube which looks untidy.(I copy this data and paste it in our internal tool IE)
How can I start every Parameter in New Line.
File Attached.
Col b has the scores, If target is met Col C shows Met or Not Met.
Col D will then display the comments based on Col C (Met/Not Met) and Col A(Parameters).
Till here everything is fine.
Row 12,13 has Strength and Focus, so all Parameters which are met should come in Strength and Not Met in Focus.
Now the final part (Overall Comments).
I want all Parameters and Comments to join together and every Parameter should start on a new line as they all come in one lube which looks untidy.(I copy this data and paste it in our internal tool IE)
How can I start every Parameter in New Line.