Shift Values to Left

1

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 - #12 by DKcrm
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:

image
image1314×767 35.6 KB

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)

2

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.

image
image1112×794 72.1 KB

End result:

image
image984×417 15.2 KB

Project is here: Shift_Values_to_Left_Problem.zip (8.9 KB)

1 Like
3

@DKcrm this is great! Thank you very much for your help and time!
Your resolved my problem! Moltes Gràcies!

1 Like