Solutions like this remind me how grateful I am to have J in my toolbox. I have a 6,000 row excel file with 75 columns that I needed to 'unpivot'
I could have used the Excel Power Query's Unpivot function, but without that or J it would have been a hassle. On Thu, Mar 17, 2016 at 10:54 PM, Henry Rich <[email protected]> wrote: > Your table is regular, so > > ,/@:(({. ,. }.)"1) > > would also work. > > Henry Rich > > > On 3/17/2016 10:47 PM, Henry Rich wrote: > >> ;@:(<@({. ,. }.)"1) >> >> Untested. >> >> Henry Rich >> >> On 3/17/2016 10:44 PM, Joe Bogner wrote: >> >>> Is there a simple or efficient transform of >>> >>> tbl =: ' ' cut every LF cut (0 : 0) >>> id col1 col2 col3 col4 col5 col6 >>> 1 ab cd ef gh hi jk >>> 2 lm no pq rs tu vw >>> 3 xy zz aa bb cc dd >>> ) >>> >>> +--+----+----+----+----+----+----+ >>> >>> |id|col1|col2|col3|col4|col5|col6| >>> >>> +--+----+----+----+----+----+----+ >>> >>> |1 |ab |cd |ef |gh |hi |jk | >>> >>> +--+----+----+----+----+----+----+ >>> >>> |2 |lm |no |pq |rs |tu |vw | >>> >>> +--+----+----+----+----+----+----+ >>> >>> |3 |xy |zz |aa |bb |cc |dd | >>> >>> +--+----+----+----+----+----+----+ >>> >>> >>> >>> to >>> >>> >>> >>> ('1';'ab'),('1';'cd'),('1';'ef'),('1';'gh'),('1';'hi'),('1';'jk'),:('2';'lm') >>> >>> >>> +-+--+ >>> >>> |1|ab| >>> >>> +-+--+ >>> >>> |1|cd| >>> >>> +-+--+ >>> >>> |1|ef| >>> >>> +-+--+ >>> >>> |1|gh| >>> >>> +-+--+ >>> >>> |1|hi| >>> >>> +-+--+ >>> >>> |1|jk| >>> >>> +-+--+ >>> >>> |2|lm| >>> >>> +-+--+ >>> >>> ... >>> >>> >>> >>> In other words, take the first column and duplicate the other columns as >>> rows >>> >>> >>> thanks in advance >>> ---------------------------------------------------------------------- >>> For information about J forums see http://www.jsoftware.com/forums.htm >>> >> >> ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
