i1 | Java projects for email sender | Microservice library

I got the following table to populate (range D6:J15) as I search the data in another sheet, based on a date criteria found in row 4:

This is where I'm to look for the data, considering Col A as the basis for the criteria:

My difficulty is to concatenate the data, as they meet the criteria.

This is the code I'm working on:

I have put example dataset (df), expected output (df2) and my code so far below. I have a df where some rows in column i2 contain a list - in the json format, which need exploding and reinserting back into the df, from the row in which they were extracted. But the need to be inputted into a different column (i1). i need to extract a unique identifier (the 'id_2' value) from the string and insert that into the id_2 column.

in my code so far i am parsing the json-like data with pd.normalize, and then inserting the original string from the column i1 onto the top of the extracted strings (it should be much more clear if you take a look below) and then reinsert them based on the index. But I have to specify the index, which is not good. I would like it to be less dependent on manual input of indices in case it changes in the future with more of these nested cells or somehow the index changes.

Any suggestions are very welcome, thanks so much

example data

When I put the formula =MAX(FILTER(I2:I,H2:H=MIN(H2:H))) in cell M2 and use =$I1=$M$2 in conditional formatting custom function it paints the entire line perfectly, but when I use the formula inside the conditional formatting custom function like this =$I1=MAX(FILTER(I2:I,H2:H=MIN(H2:H))), nothing is painted.

What do I need to adjust for this to resolve?

I am trying to create a template where I have 3 columns on the same row:

• first column adjust to its content (a picture / avatar)
• third column adjust to its content (a date or time) and the second column contains a sentence, and takes all remaining space. If the text is too long, I want it broken so that the second column does not get too big and creates a second row.

I tried this https://codepen.io/chris-eykm/pen/zYZmRKe

I'm trying to add ListColumns to a table I created in the code. I'm using an array to pull the range of cells from another sheet in a different file, to make a template of the table. When I look into the Locals window, the array is pulling the data correctly, just not renaming the headers. I'm getting an error at the commented line:

• I have a couple of columns with each different type of data for each row (person). so for example column 1 (A) contains names, column 2 (B) contains the amount of points and column 3 contains a date set by the user (if not, it's empty).

• The first problem I have is validating the input for setting a date in the sheet. right now it just pastes anything in there, So I made a workaround:

Can anyone help me in getting my this doubt clear:

I need a container that meets this scenario:

1. Needs to be a member of a class
2. Needs to contain pointers to a custom type
3. The elements are sorted using a non-unique priority value (an integer. for example: priority 0 items go before priority 1 items, before priority 2 items. Order between items of the same priority is non-important)
4. Cannot use boost or any other external library

Optionally , it would be really good if I don't have to create an additional class/struct to support sorting. Also, up to C++17 is good.

Note, I am using (auto item : collection), but if this only works with traditional iterators, that is also fine.

So for example:

I have the following data structure: