Transposing one field in a table

[andreminnaar]

Hi Guys

If I have the following data

LOAD * INLINE [
Animal, Food
Worm, Apple
Worm, Peach
Worm, Banana
Frog, Crickets
Frog, Fruit Flies
];

but I want the data in the following format

LOAD * INLINE [
Animal, Food1, Food2, Food3
Worm, Apple, Peach, Banana
Frog , Crickets, Fruit Flies
];

is there a way to do something like this?

[marcus_sommer]

Take a look here: The Generic Load - Qlik Community - 1473470

- Marcus