Lookup values to new columns like vlookup

Question

In Power Query, how can I lookup and fill the values "?" which I highlighted in yellow.

I need to fill the columns F G H, based on A&B (or Textjoin column). In short, I need to fill the last three columns in Power Query. Is there a formula like vlookup?

I tried creating a new column with conditions, but it doesn't work.

Ron Rosenfeld · Accepted Answer · 2024-10-30 19:25:29Z

1

Merely Select the Type column, and Pivot on that using Sum for the aggregation.

Select the Type column
From the Transform tab, select Pivot
Ensure the dialog box looks like:

Result

edited Oct 30, 2024 at 19:25

answered Oct 30, 2024 at 13:02

Ron Rosenfeld

62.1k7 gold badges35 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Lookup values to new columns like vlookup

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related