Expand data line by line - complicated question

[nostradamus]

Hi folks,
Below is an excel table ColA has the Date, County, and Location concatenated; and ColB has the number of birds observed at that location.
I used Multiple Consolidation Range in excel to get to this point from tabular data format.

	A	B
1	UniqueID	Value
2	42787_Bailey_a	3
3	42901_Handerson_a	2
4	42901_Handerson_b	4
5	42901_Handerson_c	5
6	42796_Atascosa_a	2
7	42796_Atascosa_b	5
8	42796_Atascosa_c	7

<tbody>
</tbody>

Question: Now, for the uniqueID in Row2 (42787_Bailey_a), there were 3 birds observed.
I need to find a way to spread the 3 out into 3 rows - as shown in the table below.
Is there a way to do it, other than manually spreading it out. I have about 3000 rows with varying values to spread out.

	A	B
1	UniqueID	Value
2	42787_Bailey_a	1
3	42787_Bailey_a	1
4	42787_Bailey_a	1
5	42901_Handerson_a	1
6	42901_Handerson_a	1
7	.	.
8	.	.

<tbody>
</tbody>

A Big Thanks.

 

[sandy666]

You are welcome
I'm happy you are happy
Now you can click on the button Thanks/Like (bottom left corner) in the posts which have helped you
Have a nice day

 

[nostradamus]

Hi sandy666, I was going through my data and the code/query only worked for first 16k lines. I have about 64k cells that would need to be populated. Is there some limitation with this table query?
Thanks.

 

[sandy666]

there is no any limits only RAM or disc space.
maybe your data somewhere is not proper
hard to say without original file

 

[sandy666]

Excel limi: ca 1 mln rows only