Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combining two rows into one row (conditionally)

Hi all,    I am trying to find a solution for the following and am wrecking my brain so any help is appreciated, I have two tables that look as follows:   Table 1 - Required:   Name   Exam     ...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,

    PBIX Obtained

     

    Appended the query, transposed the table, reordered the columns, merged the columns, split the columns by position, removed columns, then transposed table, and did clean up.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi Anonymous ,

PBIX Obtained

 

Appended the query, transposed the table, reordered the columns, merged the columns, split the columns by position, removed columns, then transposed table, and did clean up.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hope your brain recovers.:smileyhappy:

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for the quick response, let me have a look and I'll let you know :-)