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 advance  

Need Help

8 Replies

  • 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