I am looking for a process that could help me to shift/move values to the left (filling empty cells) in a table.
@DKcrm, I really appreciate your help here: Replace empty cell as text with real empty value
It was really helpful.
Now, i have this situation. My data source is a little more complicate than I thought. Basically, I need to be able to get this:
Will you be able to help me figure out a process for this? Is it possible to do it?
Shift_Values_to_Left_Problem.zip (8.6 KB)
Hi @Dinho
Try this one - The concept is similar to the other project, except this one applies a rank in order to put various values into the same column.
In this step, the value in the ‘Data’ column is ranked (type dense), in order to give each value within a client/Doc-id combination a number, to be used as column label in a later step.
End result:
Project is here: Shift_Values_to_Left_Problem.zip (8.9 KB)
@DKcrm this is great! Thank you very much for your help and time!
Your resolved my problem! Moltes Gràcies!
