Data manipulation

[Billy12excel]

Received data file per first sheet1, looking to manipulate
results to = second sheet 1

Excel Workbook
	A	B	C	D
1	LEVEL of Attainment	National Office Region	Name Upper and Lower	Ranking Position & Dollar Amount #1
2	Quadruple:
3	Top Level	North District, IL	Albert Einstein	#2 - Percent of Increase 6.0%
4	Top Level	North District, IL	Albert Einstein	#2 - Dollar Increase $2,745
5	Top Level	North District, IL	Albert Einstein	#2 New Members 10
6	Top Level	North District, IL	Albert Einstein	#1 Member Renewals 16
7	etc,etc,
8
9	Triple:
10	Mid Level	South Valley District, IL	Tony Tgier	#1 NM 105.56%
11	Mid Level	South Valley District, IL	Tony Tgier	#1 - Percent of Increase 15.6%
12	Mid Level	South Valley District, IL	Tony Tgier	#1 - Dollar Increase $9,737
13	etc,etc,
14
15	Double:
16	Lower Level	Central District, IL	Carter Mann	#2 New Members 6
17	Lower Level	Central District, IL	Carter Mann	#6 - APD $1,150
18	etc,etc,
19
20	Single:
21	Bottom Level	Central Distric, IL	Alexander Jones	#9 - APD $209
Sheet1

Excel Workbook
	A	B	C	D	E	F	G
1	LEVEL of Attainment	National Office Region	Name Upper and Lower	Ranking Position & Dollar Amount #1	Ranking Position & Dollar Amount #2	Ranking Position & Dollar Amount #3	Ranking Position & Dollar Amount #4
2	Quadruple:
3	Top Level	North District, IL	Albert Einstein	#2 - Percent of Increase 6.0%	#2 - Dollar Increase $2,745	#2 New Members 10	#1 Member Renewals 16
4	etc,etc,
5
6	Triple:
7	Mid Level	South Valley District, IL	Tony Tgier	#1 NM 105.56%	#1 - Percent of Increase 15.6%	#1 - Dollar Increase $9,737
8	etc,etc,
9
10	Double:
11	Lower Level	Central District, IL	Carter Mann	#2 New Members 6	#6 - APD $1,150
12	etc,etc,
13
14	Single
15	Bottom Level	Central Distric, IL	Alexander Jones	#9 - APD $209
16	etc,etc,
17
18	Ideally all levels saved to separate csv files
Excel 2000 Sheet1

Excel 2000


Ideally all levels saved to separate csv files

Thank you for any help!

 

[Billy12excel]

I've looked for several hours trying to find all the terms used, and their nuances, some terms I could not find as of now. I've managed to do a backdoor convoluted way to get the results desired, not much better than copy & paste, like old days. This new sheet for post, shows how it was received. All Additional rows of data like are post #13. No Column names and {1-4} , additional top rows. I'm going to find the answers, Thank you for all your patience with me.

Excel Workbook
	A	B	C	D	F
1	IL, Area 2010
2
3	Plus 3 (for their purposes, only)
4
5	Quadruple:
6	Beginner	North District, IL	Person 1	#2 - Percent of Increase 6.0%
7	All Additional rows of data like post 13
New Sheet as Received

Excel 2000