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
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