Opposite of pivot?

[ondohotola]

I can’t seem to be able to find how to do transform

A,B,C,D
a,1,2,
b,1,2,3
c,,,

with values in column A guaranteed to be unique and B, C, D being possibly empty to

A,E
a,1
a,2
b,1,
b,2
b,3
c,

the last row could be not present as the E cell would be empty, but I don’t mind.

I am not averse to RTFM so a pointer will do :-)-O

[hderms]

@ondohotola 😱 I'm shocked someone actually used qsv! I know there are some similar tools out there in the time since I created this (which was mostly something I found useful for a period at a previous job).

Unfortunately there really isn't any documentation because of how much it relies on SQLite to do the heavy lifting.

[hderms]

@ondohotola I'm guessing you could probably do something fairly manual using unions like select A, B from foo union select A, C from foo union select A,D from foo etc.. but I may have misunderstood the intention