I want to create a dynamo from this data as bellow. The value in first column should be filter out for same type of Value in column two (first value before type change. can any one suggest a way to do it?
I have managed from excel to filter out the lists expected outcome is in code block
I use a similar technique in this video (first technique) to realign excel data by matching Id to corresponding elements, which looks like a task you may also be doing:
The group by key did worked but faced some issue in it. The Group is combined for all similar type values where as i need all the values where ever type changes. See bellow image for details.
The red marked values should be the taken as per change in type value. but group by key has combined all in to one group. I have used levels and structure too but it didnt resolved the issue.