How to expand or repeat data table without loop/for

[chacachaca_li]

Hi
Are there ways insert blank or data between rows of Data table?

I have dt1, and want to using some activites or LinQ for dt2 & dt3
like that

dt1		dt2		dt3
a		a		a
c				a
b				a
1		c		c
2				c
3				c
		b		b
				b
				b
		1		1
				1
				1
		2		2
				2
				2
		3		3
				3
				3

thanks for reading

[Parth_Doshi]

Hey @chacachaca_li
Yes you can check using for each row if the row is empty then insert data or else continue to next row.
I hope this helps.

Cheers,
Parth

[chacachaca_li]

@Parth_Doshi

I hope this helps.

Cheers,
Parth

yep, already check for each row, it’s work
but It’s too many time(the data table has 1,000 rows)

[chacachaca_li]

@chacachaca_li

many

I mean ‘for each row’ for ‘write range’
I’ll try ‘for each row’ dt1…

[Parth_Doshi]

try to use filter data table.
Specify a column name
Column_Name Condition(IsEmpty)
you will see two options keep/remove then according to your requirement select Remove

[Parth_Doshi]

if this helped please mark it as solution.