Forum Discussion

chanpreet_90's avatar
chanpreet_90
Frequent Visitor
4 years ago

multiple rows into one row

  I have a data in this format and I want to combine the rows of Details into one row. please help me ...I am a beginner...I tried using Text.Combine but still getting error..   Thanks in adv...
Need Help
KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
4 years ago

HI chanpreet_90 ,

 

Below link has the solution on how to group text:

https://community.powerbi.com/t5/Power-Query/Add-Column-based-on-VLOOKUP-and-CONCATENTATION/m-p/2659021#M81574

 

Also, if you need to sum the number, you must ensure the credit sign "cr" is gone. Then, you can apply the text replace function before you use GroupBy. 

 

If you're still struggling, please provide data with sensitive info removed and in a friendly format, and I will get back to you with a step-by-step solution.

 

Regards

KT

  • chanpreet_90's avatar
    chanpreet_90
    Frequent Visitor
    4 years ago

    Thank you for you response my friend..

    I tried your solution but now im getting some 'error' in 'details', 'postdate' and 'valuedate'.

     

    I guess the error in details column is coming because it has text and number both.

    Please help

     

     

    Regards

    • KT_Bsmart2gethe's avatar
      KT_Bsmart2gethe
      Impactful Individual
      4 years ago

      Hi chanpreet_90 ,

       

      Define the data time before you apply GroupBy. Errors are general cause by a mix of data type. For those errors in the date columns, what are other values recorded under those column apart from date?

       

      If you're apply the text.combine function. The column has to be in text format.

       

      Regards

      KT

      • chanpreet_90's avatar
        chanpreet_90
        Frequent Visitor
        4 years ago

        Hey...I am able to resolve the issue coming in Details column however still getting Error in date columns. Please check and help

         

        Regards