Alternative to the pivot table

00alex00

New Member
Joined
Jun 18, 2015
Messages
40
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:

IDDateValue 1Value2IDDateValue 1Value2IDDateValue 1Value2IDDateValue 1Value2
127/02/2019AAA129227/02/2019B140327/02/2019CC28427/02/2019CCC1
126/02/2019AAA239226/02/2019B230326/02/2019CC48426/02/2019CCC65654
125/02/2019AAA34225/02/2019B44325/02/2019CC29425/02/2019CCC39876
124/02/2019AAA56224/02/2019B49324/02/2019CC46424/02/2019CCC234
123/02/2019AAA32223/02/2019B20323/02/2019CC51423/02/2019CCC5
122/02/2019AAA34222/02/2019B22322/02/2019CC51422/02/2019CCC6
121/02/2019AAA23221/02/2019B11321/02/2019CC51421/02/2019CCC54
120/02/2019AAA3220/02/2019B-9320/02/2019CC51420/02/2019CCC0
119/02/2019AAA6666219/02/2019B6654319/02/2019CC51419/02/2019CCC3
118/02/2019AAA5218/02/2019B-7318/02/2019CC51418/02/2019CCC2

<tbody>
</tbody>



I need to fill below table:

Date21/02/2019
IDValue 1Value 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
 
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.
 
Last edited:
Upvote 0

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,560
Latest member
Torchwood72

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top