Hi everyone,

I have a very long table with given columns A and B. A contains the titles of working procedures, B contains their stepwise despricption. These descriptions are spread over several cells and vary in length and amount of cells included.
My problem is the following: I need to ad a column C with a formula that automatically recognizes (by checking if a cell in column A is empty or not) the amount of cells in column B, that belong together and put them in column C accordingly. In addition, keeping a line break between the different steps that belong to one title is very important, too. Below is an example of how the whole thing should look like (note: the line brak between the steps in colum C is still missing)!

untitled 2.jpg

I hope someone knows how to do this and can help me!

BR, Arleon