Hey thanks for your update.
I am looking at something else
For example, I have 100 records,
in 1st record value is in MG L07 ID to MG L02 ID,
2nd record data is in MG L06 ID to MG L02 ID --(L7 is blank),
3rd records data is in MG L05 ID to MG L02 ID–(L7 & L6 is blank), so on
So i need output
1st Record it should capture L7
2nd record L6
3rd record L5
and so on.