Help!
My goal is to create a script or macro to take the "Group" type and add it as a column to the left -- see example below. In these examples I could then sort by Color to demonstrate the flexibility in the data. NOTE: there can be more "Groups", it is not just limited to 2 as shown in this example however the blank lines and format is consistent throughout.
Thoughts on the best approach to iterate/associate the Group name by row instead? The "." is used to assist with this posting to ensure my column/row examples line up...
Column A is blank here...
.....A......B......C......D...... E
1. ...... BLUE
2. .......Ball
3. .......Pale
4. .......Book
5. .................
6. .......Number Blue=3
7. ..................
8. .......RED
9. .......Sign
10. ......Cup
11. ......Door
12. ......Car
13. ......Poster
14. ....................
15. ..... Number Red=5
To now have my data have a 1-to-1 association and remove the grouping to perform pivots and other preferred ways to use the data, the final output would look like this essentially removing the grouping and label each row with the previous group value:
Column A would then become the Group Value
.....A......B......C......D.....E
1. BLUE....Ball
2. BLUE....Pale
3. BLUE....Book
4. RED.....Sign
5. RED.....Cup
6. RED.....Door
7. RED.....Car
8. RED.....Poster
My goal is to create a script or macro to take the "Group" type and add it as a column to the left -- see example below. In these examples I could then sort by Color to demonstrate the flexibility in the data. NOTE: there can be more "Groups", it is not just limited to 2 as shown in this example however the blank lines and format is consistent throughout.
Thoughts on the best approach to iterate/associate the Group name by row instead? The "." is used to assist with this posting to ensure my column/row examples line up...
Column A is blank here...
.....A......B......C......D...... E
1. ...... BLUE
2. .......Ball
3. .......Pale
4. .......Book
5. .................
6. .......Number Blue=3
7. ..................
8. .......RED
9. .......Sign
10. ......Cup
11. ......Door
12. ......Car
13. ......Poster
14. ....................
15. ..... Number Red=5
To now have my data have a 1-to-1 association and remove the grouping to perform pivots and other preferred ways to use the data, the final output would look like this essentially removing the grouping and label each row with the previous group value:
Column A would then become the Group Value
.....A......B......C......D.....E
1. BLUE....Ball
2. BLUE....Pale
3. BLUE....Book
4. RED.....Sign
5. RED.....Cup
6. RED.....Door
7. RED.....Car
8. RED.....Poster
