I have 3 columns that has set of rows highlighted in different color now i want to bring up the value of 2nd and 3rd column value next to the 1st column cell (no chnage in cell value )
My input data
expected output data
I have 3 columns that has set of rows highlighted in different color now i want to bring up the value of 2nd and 3rd column value next to the 1st column cell (no chnage in cell value )
My input data
Hi @BAVITHRA
This time I used the Group Loop node. See change_cells_and_row_order.knwf (44.8 KB).
I would just use the Missing Values node for this. Just select previous value for the “Document DD Column” and “Document Revision”.
After that you can use an if expression to make the values null when “Item Number” is null (assuming you really want to preserve those blank rows in the output structure), or you could just filter out the rows where “Item Number” is missing if the final goal is to get to a clean table.
Thank you so much it worked !!!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.