Hello, I’m trying to figure a formulas for columns A and B so the example on the left will look like the one on the right where the empty spaces in columb J and K are filled in. The number of rows for example in project 234 may be as few as one and as many as 30. If column C has no data then column A, B and D will also not have data. There will never be empty rows until the last row of data. Any ideals? Thanks

Attached Files

Book2.xlsm (10.2 KB, 12 views)