Qlik Sense: Fill out table with key, or rather reducing rows

[enfodavid]

How do I fill out a table that has a key and all fields (Including some empty ones) but on separate rows. Desired table is just a row per key.

This is probably easy but I've drawn a total blank

[enfodavid · Accepted solution]

Group By is what I'm looking for. I'm dumb

LOAD Only(%Key) as Key,

           Only(Field1) as Field1,

           Only(Field2) as Field1,

           Only(Field3) as Field1

FROM $Source

Group By %Key;