I'm an intermediate excel user.
I am trying to reformat a spreadsheet that takes the following into consideration:
Column A is a name -- Column B is a description for the name in A, but covers multiple rows (was exported from a software program).
I need to come up with a formula that will recognize that if there is no value in Column A, that the text in B should be concatenated to the text in the row above, and that if the text in the row above was already concatenated to the row above that, then the text should be concatenated to that row instead (and so on and so forth).
Is this possible? Would save me around 10-15+ hours of cut and paste.