Filling in the missing Cells

[sapna]

Hello,

I have a data set provided as below

Person	Location	Month	Sales
Bob	London	Jan	100
	New York	Feb	200
	London	Mar	300
Kate	New York	Jan	400
	London	Feb	500
	London	Mar	600
John	New York	Jan	100
Mark	London	Feb	200

All i need to do is fill the person  name in the blank column in qlik.

Kindly suggest a way.

[pradosh_thakur · Accepted solution]

load If(len(trim(Person))=0,peek(Person),Person) as Person , Location,	Month	,Sales Inline [
Person	,Location,	Month	,Sales
Bob	,London	,Jan	,100
	,New York	,Feb,	200
	,London,	Mar,	300
Kate,	New York,	Jan,	400
	,London	,Feb	,500
	,London	,Mar,	600
John	,New York	,Jan,	100
Mark,	London,	Feb	,200
];