N
NickG
I hope there is a solution to this...
Basically I am looking to convert a database from the format below into
a 'horizontal' Excel database.
Only problem being I want each row to contain:
a) the first 9 values in the first row
b) then the next 3,
c) then the next 15
d) then the next x sets of 52 values where x is the number shown at the
end of the 15 (23 in this case)
Code:
--------------------
israeli
5
7
4
5
92
3
0
2 division
ligat ha'al
12 teams
beitar jerusalem
b. jerusalem
8
0
0
5
5
9
5
0
9
9
5
9
23
Basically I am looking to convert a database from the format below into
a 'horizontal' Excel database.
Only problem being I want each row to contain:
a) the first 9 values in the first row
b) then the next 3,
c) then the next 15
d) then the next x sets of 52 values where x is the number shown at the
end of the 15 (23 in this case)
Code:
--------------------
israeli
5
7
4
5
92
3
0
2 division
ligat ha'al
12 teams
beitar jerusalem
b. jerusalem
8
0
0
5
5
9
5
0
9
9
5
9
23