Forum Discussion
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...
HI chanpreet_90 ,
Below link has the solution on how to group text:
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
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