how to replicate the line above

[Sshasnk]

I have a dataset, where some of the columns are null I have to fill the data which is above

Example: 

name	last name	location	date	rate	price	code	ad id
adam	smith	LN	2020-12-01	0.21	547	785	456
			2020-12-02		475
			2020-12-03		478
Kelly	cuco	USA	2020-12-04	0.25	478	745	712
Eve	kane	UK	2020-12-05	0.14	5214	241	358
			2020-12-06		547
jake	rom	IK	2020-12-07	0.54	475	145	254

if you will see the name, last name, location, rate, code, and ad id have a null value below So I have to change it with whatever I have above

and date and price will never be null

Output"

name	last name	location	date	rate	price	code	ad id
adam	smith	LN	2020-12-01	0.21	547	785	456
adam	smith	LN	2020-12-02	0.21	475	785	456
adam	smith	LN	2020-12-03	0.21	478	785	456
Kelly	cuco	USA	2020-12-04	0.25	478	745	712
Eve	kane	UK	2020-12-05	0.14	5214	241	358
Eve	kane	UK	2020-12-06	0.14	547	241	358
jake	rom	IK	2020-12-07	0.54	475	145	254

[Emil_Kos]

Hi @Sshasnk,

I have created a workflow for you:

Please see the output:

[afv2688]

Hello @Sshasnk ,

This should do it 🙂

Regards