@@datacense for example in one column I have all dates in sequence and in other column I have values with respect to dates (in the values some has greater than zero and some has only 0) .. So I want to group the dates in manner that let's say (05-04-2021 to 10-04-2021) has (1,2,3,4,5) I.e 5 number and (11-04-2021 to 13-04-2021) has (0,0,0) I.e. 3 number Again (14-04-2021 to 20-04-2021) has (56,57,58,10,60,75,80) has 6 values Again (21-04-2021 to 30-04-2021) has (0,0,0,0,0,0,0,0,0,0) has 10 values.. I have very big data and I have to group in this manner.. Is there in trick to solve it. Could you help me to sort this issue..?
@@abrarhaware3007 we can think on this please mail your sample data to support@datacense.com I have one question how do you decide first group will have 5 entries second have 3 and third have 6 entries. Is there a logic to that
Hi. I need to ctreate a sepreadsheet with 5 rows per workday. Any ideas how to do that?
Is it possible to create the list but in columns?
How to reverse work of this method?? Like if I have multiple dates in and grouping them in (1-Jan -2022 to 5-jan-2022), (8-jan-2022 to 12-jan-2022)
what would be the basis of groups. i can see jan itself has 2 groups.. how to know which dates belong to a group. 4 days 5 days or any other logic
@@datacense for example in one column I have all dates in sequence and in other column I have values with respect to dates (in the values some has greater than zero and some has only 0) ..
So I want to group the dates in manner that let's say (05-04-2021 to 10-04-2021) has (1,2,3,4,5) I.e 5 number
and (11-04-2021 to 13-04-2021) has (0,0,0) I.e. 3 number
Again (14-04-2021 to 20-04-2021) has (56,57,58,10,60,75,80) has 6 values
Again (21-04-2021 to 30-04-2021) has (0,0,0,0,0,0,0,0,0,0) has 10 values..
I have very big data and I have to group in this manner.. Is there in trick to solve it. Could you help me to sort this issue..?
@@abrarhaware3007 we can think on this please mail your sample data to support@datacense.com
I have one question how do you decide first group will have 5 entries second have 3 and third have 6 entries. Is there a logic to that
@@datacense ok.. I will send you and explain same in sheet only