Hello I am searching an alternative to the pivot table.
Since the pivot table works only if data are in the same header (column) how can I select a certain type of date for a given reference?
Let me explain here. I have a similar situation as below:
<tbody>
</tbody>
I need to fill below table:
<tbody>
</tbody>
Since I have more than 4 ids I don't want to put them manually under the same column.
Is there an index match or some other formula to search values for a specific date?
Thanks
Since the pivot table works only if data are in the same header (column) how can I select a certain type of date for a given reference?
Let me explain here. I have a similar situation as below:
ID | Date | Value 1 | Value2 | ID | Date | Value 1 | Value2 | ID | Date | Value 1 | Value2 | ID | Date | Value 1 | Value2 |
1 | 27/02/2019 | AAA | 129 | 2 | 27/02/2019 | B | 140 | 3 | 27/02/2019 | CC | 28 | 4 | 27/02/2019 | CCC | 1 |
1 | 26/02/2019 | AAA | 239 | 2 | 26/02/2019 | B | 230 | 3 | 26/02/2019 | CC | 48 | 4 | 26/02/2019 | CCC | 65654 |
1 | 25/02/2019 | AAA | 34 | 2 | 25/02/2019 | B | 44 | 3 | 25/02/2019 | CC | 29 | 4 | 25/02/2019 | CCC | 39876 |
1 | 24/02/2019 | AAA | 56 | 2 | 24/02/2019 | B | 49 | 3 | 24/02/2019 | CC | 46 | 4 | 24/02/2019 | CCC | 234 |
1 | 23/02/2019 | AAA | 32 | 2 | 23/02/2019 | B | 20 | 3 | 23/02/2019 | CC | 51 | 4 | 23/02/2019 | CCC | 5 |
1 | 22/02/2019 | AAA | 34 | 2 | 22/02/2019 | B | 22 | 3 | 22/02/2019 | CC | 51 | 4 | 22/02/2019 | CCC | 6 |
1 | 21/02/2019 | AAA | 23 | 2 | 21/02/2019 | B | 11 | 3 | 21/02/2019 | CC | 51 | 4 | 21/02/2019 | CCC | 54 |
1 | 20/02/2019 | AAA | 3 | 2 | 20/02/2019 | B | -9 | 3 | 20/02/2019 | CC | 51 | 4 | 20/02/2019 | CCC | 0 |
1 | 19/02/2019 | AAA | 6666 | 2 | 19/02/2019 | B | 6654 | 3 | 19/02/2019 | CC | 51 | 4 | 19/02/2019 | CCC | 3 |
1 | 18/02/2019 | AAA | 5 | 2 | 18/02/2019 | B | -7 | 3 | 18/02/2019 | CC | 51 | 4 | 18/02/2019 | CCC | 2 |
<tbody>
</tbody>
I need to fill below table:
Date | 21/02/2019 | |
ID | Value 1 | Value 2 |
1 | ||
2 | ||
3 | ||
4 |
<tbody>
</tbody>
Since I have more than 4 ids I don't want to put them manually under the same column.
Is there an index match or some other formula to search values for a specific date?
Thanks