Loading Exel with group rows

[SSD_KKL]

Hello!.

I am trying to read an excel in QlikView where the values ​​of some columns have 2 or 3 options in other rows,
and it is only taking the last value of right.

*The green ones

And I need a table in qlik where each product has the 2 or 3 options in the month and delivered rows.

For example, having the Water product 3 times with January, February and March. Ex:

How could it be done?

Thanks!

[Luis_Galvan]

Hi, 

You can try using Peek() function. Here is the help link.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/InterRe...

This function will allow you to grab (peek) a value in the "n" row based on the current record set position. Ex, if you need to peek previous value for Product field, you can use:

Peek('Product')

You might have to look for previous 2 (or 3) rows if you know that wrap text is limited to x number of rows.