Kind of Transpose

[Anonymous]

LOAD * INLINE [

    Field, David, Mark, Lea, Nathalie, John

    Country, Poland, Poland, England, England, France

    Town, Krakow, Krakow, Leeds, London, Paris

    Pet, Dog, Cat, Rabbit, Dog, Bear

];

I would like to have the result like in the green Table box, but instead of a table box I would like to use a straight table ... BUT without having to populate the names manually (I have many of them and keep growing).

Thank You,

Raphael

[sunny_talwar]

Have you considered using The Crosstable Load?

CrossTable (Name, Data)

LOAD * INLINE [

    Field, David, Mark, Lea, Nathalie, John

    Country, Poland, Poland, England, England, France

    Town, Krakow, Krakow, Leeds, London, Paris

    Pet, Dog, Cat, Rabbit, Dog, Bear

];

[tresesco · Accepted solution]

Use crosstable() like:

Crosstable(Names,Values) LOAD * INLINE [

    Field, David, Mark, Lea, Nathalie, John

    Country, Poland, Poland, England, England, France

    Town, Krakow, Krakow, Leeds, London, Paris

    Pet, Dog, Cat, Rabbit, Dog, Bear

];

And then use pivot in the UI

[Anonymous]

Thanks, I did , also did consider Generic loading but that is nor what I am after.

[sunny_talwar]

Then what exactly are you trying to get?

[Anonymous]

Thank you that is what I was after

[Anonymous]

I was after the below from Tresesco, just I did not specify it correctly, I did not realize you could use a Pivot table for that, thank you.