Help with Pulling in List to copy Dates

[urkas]

I have a set number of dates that I need to forecast. Some of the months I have dont always have a Forecast but I want to be able to at least post a 0 still in that date.

What I need is to be able to use a list of parts IE

301080.01
301081.01
301082.01
301083.01

Etc ( this parts will be somewhat all over the place as part as how they may look )

And from there I want to have them formatted as follows.

And just have this repeat through all the parts I have listed.

Ideally I would want to be able to set my Range at the top of this Excel sheet

IE two cells - Start and End Date

[TABLE="width: 290"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD]Item[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]9/1/2019[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]10/6/2019[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]11/3/2019[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]12/1/2019[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]1/5/2020[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]2/2/2020[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]3/1/2020[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]4/5/2020[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]5/3/2020[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]6/7/2020[/TD]
[/TR]
[TR]
[TD]301080.01[/TD]
[TD]7/5/2020[/TD]
[/TR]
</tbody>[/TABLE]

 

[sijpie]

Hi Urkas,

Don't really understand what you require.

What i think you want is:
For each partnumber in the list create a table with the partnumber in the first column and a list of dates (first sunday of the month) in the 2nd column.

Do you want a sepearte list for each part number or do you want these below each other?

As an alternative:
Why not use a table with partnumbers in the left column and dates in the top row?