Creating a Pivot and bringing multiple columns and doing vlookup

I have prepared a mock-up for you.

and the output:

Please mark as an answer it is something helpful

Join.yxmd

Please let me know if this the desired output:

Join 2.yxmd

Hi @sriniprad08

I would suggest using find and replace instead of join for vlookup.

Join will create 1-many match there by creating multiple rows

Here is the workflow

Output A:

Output B: Find and replace

Join: creates more rows.

Workflow:

Hope this helps 🙂

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

name.yxmd

I have prepared a workflow for you:

Output:

Formula Indicator.yxmd

Hi @sriniprad08

Here is the modified workflow.

Output:

Workflow:

Hope this helps 🙂

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

name.yxmd

All comments

If you are asking about output B I believe you need to use join tool and join the data on the ID column

I have prepared a mock-up for you.

and the output:

Please mark as an answer it is something helpful

Join.yxmd

sriniprad08

hi @Emil_Kos ,

Thank you. How can i solve Output A. Where I need to bring Vendor name as well?

Cheers,

Sriniv

Hi @sriniprad08

Sorry my bad to get vendor name also.

Just select column in join tool.

But it looks more like a grouby ID & name and sum of cost. Numbers match.

Please let me know if this the desired output:

Join 2.yxmd