Alternative to the pivot table

[00alex00]

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:

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

 

[Fazza]

If you can, everything will be easier with well structured data. Such as re-arrange the data to a single table.

For info, a pivot table can be made from poorly structured data - it is just an example of combining data from more than one table. Suggest you google.