dataframe issue: I am trying to concatenate a value of a cell with previous cell if a certain condition is met.
Assume this is the data and i want to concatenate the value of those where column A is not null and other columns are to the previous cells
for eg I want to concatenate the row 4and 3, 7 and 6 thereby dropping the row 4 and 7
expected output should be
This is a sample data, my original dataframe consists of multiple rows