Find "the parent" of the last element with non-blank cells

[Javier070590]

Dear All,

Could you please help me with my problem?

I have a table with last 2 columns fully populated. I need a parent of those elements from columns from LVL1_ID to LVL6_ID, parent will be first non-blank cell from the right side. So for line first parent is 333 (LVL3_ID), for the second line 111 (LVL1_ID), for third 222 (LVL2_ID) etc. 

LVL1_ID	LVL2_ID	LVL3_ID	LVL4_ID	LVL5_ID	LVL6_ID	Leaf_element_ID	Leaf_element_ID
111	222	333				xxx	Element_1
111						xxx	Element_2
111	222					xxx	Element_3
111	222	333	444	555		xxx	Element_4
111	222	333				xxx	Element_5

I really appreciate support!

Best regards,

Marcin

[echuong1 · Accepted solution]

You can pivot the data and then get the last non-empty value. See attached for an example. Hope this helps!

[atcodedog05 · Accepted solution]

Hi @Javier070590 ,

Here is a workflow for the task.

Hope this helps : )

If this helps please mark the post as solution

[Javier070590]

Thank you, both solutions were brilliant!

[atcodedog05]

Happy to help : )