Forum Discussion

ak77's avatar
ak77
Post Patron
3 years ago
Solved

Multiple columns to Multiple Rows in power query

hi Team,   I have 3 million records with 8 columns coming from DB table . i need help to get the fast way in power query to transpose 1 record to 3 rows as below: Col4,Col7 should be transposed un...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    In our file itself, just paste the M code.  It will work fine.

ak77's avatar
ak77
Post Patron
3 years ago

Thanks Ashish_Mathur . some syntax issue when i  tried before .. got it fixed and running fine when i copy pasted your M code again .Thanks again