Arrange informayion in table

[Gmoz]

Hello all,
Quick question, I have a table inported from an Excel sheet with tons of information. The table is set up like this
CODE.......YEAR.......L1............. L2............ L3............ L4
...A...........2000........5..............9..............3..............6
...A...........1999........2..............8..............7.............12
...B...........2000........1..............6..............4..............2
...B...........1999........7..............5..............9..............15


Now the problem is I need to query it by Code, Year, and L#
( Example A 1999 L3 = 7) Now I know I could make a colume called L# or somthing llike that and make the table look like this
.Code........Year...........L#..........Value
...A........... 2000...........1..............5
...A............2000...........2..............9
...A............2000...........3..............3

But with 1500 rows all ready that would make for a big table and a lot of work. Any idaes would be greatly appreciated.

 

[Gmoz]

Wow,
I did not think this would be above the great knowledge of this forum, I have gotten so much good info here. Still have not found a soultion so again any help is appreciated.

 

[Gmoz]

Thanks

Thanks Pat!!! I got it now. I guess I just needed a bit of a brain stimulation. Still going to take a little time because I have 50 L# lines but at least I know what need to be done now.Thanks again for your help!!