Hello!
I have a exit interview survey that individuals are able to select multiple reasons as to why they are leaving the company. When I pull the raw data it puts all the reasons they selected into a new column. I would like to put all the reasons into one cell, which I can do using the CHAR(10) function, however if the person did not select a reason, it will still put a line break there.
Example Data:
[/tr]
My Formula in Col H is:
=CONCATENATE(a1,CHAR(10)&b1,CHAR(10)&c1,CHAR(10)&d1,CHAR(10)&e1,CHAR(10)&f1,CHAR(10)&g1)
As you can see it puts line breaks regardless to if that cell has value.
I would like the results of EE A to be:
Better schedules
Other (please specify)
So if that person didn't select that reason, it will not give it a line break. I have a feeling this is a macro or a VERY long If statement, which I'm not opposed to but I have to manually do this report monthly and I'm tired of copying and pasting. LOL
OR, if someone can tell me how to do a REPLACE function for a line break, that would work too!
Your help is greatly appreciated!
TIA!
I have a exit interview survey that individuals are able to select multiple reasons as to why they are leaving the company. When I pull the raw data it puts all the reasons they selected into a new column. I would like to put all the reasons into one cell, which I can do using the CHAR(10) function, however if the person did not select a reason, it will still put a line break there.
Example Data:
A | B | C | D | E | F | G | H |
CHOICES (Column)/EE Name (Row) | Better pay | Promotional position with more pay and/or responsibility | Better benefits package to include tuition reimbursement, medical, 401k and vacation | Better schedules | Less responsibility for equal pay or more pay | Other (please specify) | <B>RESULTS</B> |
EE A | Better schedules | Other (please specify) | Better schedules Other (please specify) | ||||
EE B | Better pay | Promotional position with more pay and/or responsibility | Less responsibility for equal pay or more pay | Better pay Promotional position with more pay and/or responsibility Less responsibility for equal pay or more pay | |||
EE C | Better pay | Promotional position with more pay and/or responsibility | Better benefits package to include tuition reimbursement, medical, 401k and vacation | Better pay Promotional position with more pay and/or responsibility Better benefits package to include tuition reimbursement, medical, 401k and vacation | |||
[/tr]
My Formula in Col H is:
=CONCATENATE(a1,CHAR(10)&b1,CHAR(10)&c1,CHAR(10)&d1,CHAR(10)&e1,CHAR(10)&f1,CHAR(10)&g1)
As you can see it puts line breaks regardless to if that cell has value.
I would like the results of EE A to be:
Better schedules
Other (please specify)
So if that person didn't select that reason, it will not give it a line break. I have a feeling this is a macro or a VERY long If statement, which I'm not opposed to but I have to manually do this report monthly and I'm tired of copying and pasting. LOL
OR, if someone can tell me how to do a REPLACE function for a line break, that would work too!
Your help is greatly appreciated!
TIA!