data formating

[NavinReddy]

Hello All,

Could someone help me, how could i format the excel data like below image format. kindly help me i would like to format attached excel data below image format.

Regards,

Navin

[NavinReddy]

kindly help me with the suggestions 

[Frank_Hartmann · Accepted solution]

see attached.

hope this helps

[NavinReddy]

Thanks a lot for your help.  

[NavinReddy]

Thanks a lot for your help

[NavinReddy]

@Frank_Hartmann

sorry if i want to implement same logic with dynamic data, how could i implement, my data will changes based on selection, kindly help me. 

[Frank_Hartmann]

can u share a sample qvw and a description of the expected behaviour?

[NavinReddy]

@Frank_Hartmann sorry for my later reply,

i have added the sample data, i was not able to implement your logic. kindly help me 

[Frank_Hartmann]

How do you determine which header to use for the ID´s?  is there any logic how you assign the IDs to the headers. How many Headers do you need?

[NavinReddy]

i want to disply all the list of IDs belongs to the header, we already have mapping. i would like to disply based on header assinged ids. Header under list of IDs.