How To Summary Data and Join it in one row by Group

Question

Kindly help to suggest "How To use script/formula to summary data and Join it in one row by Group?"  thanks a lot.

Table I  Table IINameShift  NameShiftLilyJan  LilyJan/Jul/OctTomFeb  TomFeb/May/DecJohnMar  JohnMar/Jun/SepKevinApr  KevinApr/Aug/NovTomMay    JohnJun    LilyJul    KevinAug    JohnSep    LilyOct    KevinNov    TomDec

Thierry_S · Answer

Hi,

Here is the manual way to do this:
1) Split Table 1 Column Shift by Name (Table > Split)
2) Transpose the resulting table (Table > Transpose)
3) Concatenate the columns containing the shift information: select all 3 columns, right-click on the column header > New Formula Column > Concatenate with comma -> Table 2
Note, you can opt to change the delimiter (",") in the formula editor with whatever character you wnat.
Best,

TS