I am trying to create a new table by pulling the process numbers corresponding to the date

[Interfectus]

Book1.xlsx

,Hello everyone,

I am trying to prepare the process numbers and dates in the date ranges in the table on the left one by one in the form of the table on the right, but I could not succeed, if anyone can help, I would be very grateful.

[dosydos]

This will put the dates in Oldest to Newest in column I.
In I5 and then drag down:

Please Login or Register  to view this content.

Depending on your locale you may need to use this formula below instead as I am unsure if Turkey uses commas or semicolons.

Please Login or Register  to view this content.

[sandy666]

something like this ?

Date		Date	Mac.5	Mac.4	Mac.3
28/11/2022		28/11/2022	8247592	8169509	8168259
30/11/2022		28/11/2022	8244159		8218619
		28/11/2022		8230440	8172228
		28/11/2022		8252143	8172205
		28/11/2022			8182345
		30/11/2022	8171846	8217887	8169375
		30/11/2022	8247899		8169375
		30/11/2022	8168517
		30/11/2022	8195135	8259480
		30/11/2022		8250160
		30/11/2022		8169800

[Interfectus]

Yes,exactly like this !

[Interfectus]

Yes, but there are more than one P.nos for one date

[sandy666]

Yes,exactly like this !

so you can use Power Query

[sandy666]

Yes, but there are more than one P.nos for one date

if you add date to small blue table and refresh green table it will show you more Pnos
in this example I use two dates and you see all Pnos for these two dates

btw. in your source "table" you have

Mac. 3

but should be

Mac.3

litttle big problem one space too much

[Interfectus]

Oh my god ! I gotta learn how to do this. Thank you so much..

[sandy666]

for a good start try this: Learn Power Query