Append with new column if duplicates

[Kk_larsen]

Hi guys!

I hope you can help, and I hope this is possible. 

I have a dataset where I need to have an upper limit and a lower limit, but the problem right now is that these limits are in seperate rows with the same ID and parameter (as you can see on the first picture)

What I want is a unique row with the ID and parameter and then two columt the lower and upper limit like this:

Is this possible? 🙂

[atcodedog05]

Hi @Kk_larsen 

This is definitely possible. Can you provide data in excel file.

[Kk_larsen]

Nice to hear - I have attached a sample of the data here 🙂

@atcodedog05 

[atcodedog05]

Hi @Kk_larsen 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍