Hello community! I would like some help with this. I somehow did it manually, but I would want to learn how to do it with a more sophisticated code. I need to split this grid into columns (up to 12 columns), with the following conditions:  - If it is a "C" or a "-" it must go in a single column.  - If it is a number, example "03" "09" "23", it must go in a single column.   Example:   Obs GRID Column1 Column2 Column3 Column4 … Column 12 1 13131313130706050403--01CCCCCCCC 13 13 13 13     2 CCCCCCCCCCCCCCCCCCCCCC C C C C     3 13130234 13 13 02 34     4 13131354 13 13 13 54     5 CC020101CCC01CC01CC01CC-- C C 02 01     6 --C20133 - - C 20     7 C0201CC C 02 01 C     8 C030201C C 03 02 01       Thanks in advance!! ... View more

Hello guys!   I'm struggling to achieve this, but I can't find the solution. What I need to do, is to count the records where the inquiry_date is older than the per_obs, for each per_obs, and make it accumulative for each id. So, it must restart when the ID changes. (the per_obs is set at the beginning of the month):   This is the original table: ID INQUIRY_DATE PERIOD A 9/12/2019 2019-12 A 9/12/2019 2019-12 A 9/12/2019 2019-12 A 4/11/2019 2019-11 A 19/10/2019 2019-10 A 19/10/2019 2019-10 A 8/10/2019 2019-10 A 20/9/2019 2019-09 A 21/8/2019 2019-08 A 21/8/2019 2019-08 A 28/7/2019 2019-07 A 26/7/2019 2019-07 B 23/8/2018 2018-08 B 23/8/2018 2018-08 B 9/8/2018 2018-08 B 13/7/2018 2018-07 B 25/6/2018 2018-06 B 11/5/2018 2018-05 B 18/4/2018 2018-04   This is what I need: ID INQUIRY_DATE PERIOD Accumulative Inquiry dates A 9/12/2019 2019-12 9 A 9/12/2019 2019-12 9 A 9/12/2019 2019-12 9 A 4/11/2019 2019-11 8 A 19/10/2019 2019-10 5 A 19/10/2019 2019-10 5 A 8/10/2019 2019-10 5 A 20/9/2019 2019-09 4 A 21/8/2019 2019-08 2 A 21/8/2019 2019-08 2 A 28/7/2019 2019-07 0 A 26/7/2019 2019-07 0 B 23/8/2018 2018-08 3 B 23/8/2018 2018-08 3 B 9/8/2018 2018-08 3 B 13/7/2018 2018-07 3 B 25/6/2018 2018-06 2 B 11/5/2018 2018-05 1 B 18/4/2018 2018-04 0   Any help would be awesome, thanks a lot!     ... View more