Usually if i put data into text, the columns get all messed up and people can't read the data set in a post using text. But here goes.
Original data set
RowNum
Geography
Group
Sub-Group
Measure
Footnote1
Parents
PeerGroup
1
NK
Hair
Long
18
Inches
Same
Different
2
NK
Hair
Short
1
Inches
Different
Same
3
NK
Eyes
Brown
1
1=Brown, 2=Blue,3=Green,4=Combo
Same
Same
4
NK
Eyes
Blue
2
1=Brown, 2=Blue,3=Green,4=Combo
Same
Different
5
NK
Eyes
Green
3
1=Brown, 2=Blue,3=Green,4=Combo
Different
Different
6
NK
Height
Above
6.2
Feet
Different
Same
7
NK
Height
Below
5.7
Feet
Same
Different
8
NK
Height
Average
5.8
Feet
NA
Same
I want to add these rows
9
NK
Hair
None
0
Inches
Different
Same
10
NK
Eyes
BlueGreen
4
1=Brown, 2=Blue,3=Green
Same
Different
... View more