Excel Data Modification

[useri123]

Image 1 is the excel file,image2 is the required output, what script can be used in qliksense for that output?

[Or]

I don't see any relationship between the lines, but if it's always two consecutive lines, peek() should work.

[Digvijay_Singh]

As suggested by @Or solution depends on how your data looks like, I tried below peek and join combination, could be a better solution based on your situation - 

input:

Load value_u2,id,if(len(id)=0,peek(id),'') as id1
inline [
value_u2,id
value1,88
value2,
value3, 78
value4,
value5,79
value6
]
;

NoConcatenate

temp1:
Load value_u2,id
resident input
Where len(id)>0;

NoConcatenate

temp2:
Load value_u2 as value,id1 as id
resident input
Where len(id)=0;

left join(temp1)
Load value,id
resident temp2;

drop table input,temp2;

[useri123]

Hi,the input file is excel, what can be done for that instead of inline?

[useri123]

DataFile