J
jeanulrich00
Hi
I have imported a range from Excel that contains over 65 columns and
200 rows; so my access table as 65 fields. First field is ID (unique
no duplicate)
60 of those columns represent periods (months). First column out of
the 60 columns is Period1, second column is Period2, then Period 3,
Period4 ....till period 60
Names for those 60 fields in my table are M01, M02, M03 ..and so on
until M60
What I want to obtain is a table with 12,000 records (60 columns x 200
rows) that would look like this
ID Period Value
1 1 M01
1 2 M02
1 3 M03
1 4 M04
1 5 M05
1 6 M06 till Period 60 and value till M60 then
2 1 M01
2 2 M02
2 3 M03
2 4 M04
2 5 M05
2 6 M06 till Period 60 and value till M60 then
I think it could be possible with coding (maybe SQL code) but I am not
familiar with SQL
Thanks for helping
I have imported a range from Excel that contains over 65 columns and
200 rows; so my access table as 65 fields. First field is ID (unique
no duplicate)
60 of those columns represent periods (months). First column out of
the 60 columns is Period1, second column is Period2, then Period 3,
Period4 ....till period 60
Names for those 60 fields in my table are M01, M02, M03 ..and so on
until M60
What I want to obtain is a table with 12,000 records (60 columns x 200
rows) that would look like this
ID Period Value
1 1 M01
1 2 M02
1 3 M03
1 4 M04
1 5 M05
1 6 M06 till Period 60 and value till M60 then
2 1 M01
2 2 M02
2 3 M03
2 4 M04
2 5 M05
2 6 M06 till Period 60 and value till M60 then
I think it could be possible with coding (maybe SQL code) but I am not
familiar with SQL
Thanks for helping