The first attachment is the raw data, and I hope to combine the all values of each row into one row and remove all cells without values, like the second document. And I cannot figure out how to do these by PP components. Need help!