Forum Discussion

CHARLEA1's avatar
CHARLEA1
Frequent Visitor
4 years ago
Solved

Unmerging dataset

Hi there,  I have data that is strangely structured like the following: ColumnA   ColumnB A                 B B                 C and I want to find a way to conver the data to the following...
Need Help
  • CHARLEA1's avatar
    CHARLEA1
    4 years ago

    Following up with this thread that I have solved my issue via merging my table with the same table referencing column B as column A

CHARLEA1's avatar
CHARLEA1
Frequent Visitor
4 years ago

Hi Nate,

using your formula as: = Table.AddColumn(#"Changed Type", "Custom", each if List.Contains(#"Changed Type"[Column1], [Column2]) then [Column2] else null)

It yields the following result:
Column1   Column2   Custom
A               B                B
B               C                null

Is there a way to pull the column2 value relevant to the row in which it matched from column1?