Discussions

I have data for employees working on different projects as in the below example where A,B,C,D,E,& F represents projects.   Employee ID A B C D E F 1 Yes Yes         2     Yes Yes     3 Yes     Yes   Yes 4       Yes     5         Yes     I want to add a new column in which all the projects assigned to a employee will be consolidated separated by a comma. Something like in the below table. Employee ID A B C D E F Employee Projects 1 Yes Yes         A,B 2     Yes Yes     C,D 3 Yes     Yes   Yes A,D,F 4       Yes     D 5         Yes   E   Can someone please help on this. TIA !   Rishi ... View more

i have the below data set. so what i want is to create rows anywhere NBD is NOT 1. for example, for 12/12, NBD = 3.  i want to "fill the gap" by creating 2 rows. one for 12/13 and one for 12/14 with all the data from 12/12. the numbers of rows i need created would be determined by the number in the NBD column - 1.     start:   Begin Date NBD INC RATIO  INT INC   AMORT   STGL  12/11/2025 1 4.52      1,474,492.49     154,906.01    12,987.71 12/12/2025 3 4.35      1,392,897.43     189,854.47     (1,507.33) 12/15/2025 1 4.77      1,565,859.49     172,362.66                        -   12/16/2025 1 4.33      1,402,171.60     177,340.59     (4,281.20) 12/17/2025 1 5.34      1,705,424.20     218,535.97    18,488.18 12/18/2025 1 4.38      1,398,298.55     195,066.07                        -   12/19/2025 3 4.71      1,533,445.90     184,799.98                  0.78 12/22/2025 1 4.89      1,588,527.00     200,739.36     (4,469.60)   end state: Begin Date NBD INC RATIO  INT INC   AMORT   STGL  12/11/2025 1 4.52      1,474,492.49     154,906.01    12,987.71 12/12/2025 3 4.35      1,392,897.43     189,854.47     (1,507.33) 12/13/2025 3 4.35      1,392,897.43     189,854.47     (1,507.33) 12/14/2025 3 4.35      1,392,897.43     189,854.47     (1,507.33) 12/15/2025 1 4.77      1,565,859.49     172,362.66                        -   12/16/2025 1 4.33      1,402,171.60     177,340.59     (4,281.20) 12/17/2025 1 5.34      1,705,424.20     218,535.97    18,488.18 12/18/2025 1 4.38      1,398,298.55     195,066.07                        -   12/19/2025 3 4.71      1,533,445.90     184,799.98                  0.78 12/20/2025 3 4.71      1,533,445.90     184,799.98                  0.78 12/21/2025 3 4.71      1,533,445.90     184,799.98                  0.78 12/22/2025 1 4.89      1,588,527.00     200,739.36     (4,469.60) ... View more