nostradamus
Board Regular
- Joined
- Aug 9, 2010
- Messages
- 143
- Office Version
- 365
- Platform
- Windows
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.
<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.
<tbody>
</tbody>
A Big Thanks.
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.