<div>
<div class="content wysiwyg-content">
I have two columns in excel, one for unique I'd and second total data, &nbsp;in below example I would like to explain<br />
I'D. &nbsp; total data<br />
12. &nbsp; &nbsp; 5<br />
14. &nbsp; &nbsp; &nbsp;60<br />
18. &nbsp; &nbsp; 44<br />
<br />
I would like to create 5 rows for I'd 12 with starting from 01.01.2016, 60 rows for I'd 14 with starting date from 01.01.2016, it should look like below<br />
I'd. &nbsp; date<br />
12. &nbsp; &nbsp;01.01.2016<br />
12. &nbsp; &nbsp;01.02.2016<br />
12. &nbsp; &nbsp;01.03.2016<br />
12. &nbsp; &nbsp;01.04.2016<br />
12. &nbsp; 01.05.2016<br />
<br />
how I can do that, I have many records that I want to create dates for that
</div>
</div>


I have two columns in excel, one for unique I'd and second total data,  in below example I would like to explain
I'D.   total data
12.     5
14.      60
18.     44

I would like to create 5 rows for I'd 12 with starting from 01.01.2016, 60 rows for I'd 14 with starting date from 01.01.2016, it should look like below
I'd.   date
12.    01.01.2016
12.    01.02.2016
12.    01.03.2016
12.    01.04.2016
12.   01.05.2016

how I can do that, I have many records that I want to create dates for that

excel 2013

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.