Datatable manipulation

[nagaabhishekreddy.c]

Hi all,
I have a datatable which has following structure

A	B	C
John	california, textas	678
abram	new jersy	789
	houston,chicago
	india
jacob	australia, spain	5678
	brazil
armani	canda,germen	7890

i need the output to be like below

A	B	C
John	california, textas	678
abram	new jersy,houston,chicago,india	789
jacob	australia, spain,brazil	5678
armani	canda,germen	7890

When column A contains empty row then the column bhas to append to the previous roe columnB

[Anil_G (Anil Gorthi)]

Hi @nagaabhishekreddy.c

Please find attached xaml. I hope you can replicate it for the required number of columns and your data

ExcelMerge.xaml (12.1 KB)

I did it with two columns and 5 rows check the build datatable

cheers

[nagaabhishekreddy.c]

Thanks, it worked