How To Summary Data and Join it in one row by GroupKindly 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 II |
| Name | Shift | | | Name | Shift |
| Lily | Jan | | | Lily | Jan/Jul/Oct |
| Tom | Feb | | | Tom | Feb/May/Dec |
| John | Mar | | | John | Mar/Jun/Sep |
| Kevin | Apr | | | Kevin | Apr/Aug/Nov |
| Tom | May | | | | |
| John | Jun | | | | |
| Lily | Jul | | | | |
| Kevin | Aug | | | | |
| John | Sep | | | | |
| Lily | Oct | | | | |
| Kevin | Nov | | | | |
| Tom | Dec | | | | |
ScriptingRe: How To Summary Data and Join it in one row by GroupHi,
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
