Forum Discussion

MickThurman's avatar
MickThurman
Frequent Visitor
5 years ago
Solved

Transposing data

Hi, I have a table which is a long list of materials, some of which are duplicates - in that they are the same material but with a different number. Fortunately, as can be seen in the picuture, these...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi MickThurman 

    You can try merge function in power query editor.

    Firstly we need to duplicate this table in power query editor.

    Keep first top row in Table(2)

    Then merge Table (2) and Table by Old material number column in Table(2) and Legacy Material Number column in Table.

    Final expand all rows in Table.

    Result is as below.

    All elements will show in one row.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

so you want one row, but to keep all the legacy attributes but in one row, is that what you are saying?  how will you be using this data?

MickThurman's avatar
MickThurman
Frequent Visitor
5 years ago

Hi, Yes one row, for these data. Will be using the data against a raft other attributes from other tables to manage their consolidation.