Expected results: from the above case, each column * corresponding numerical value and its upper conditions, create a new file, the following form,

Case no. 01
A
1
C
6
02
A
2
B
@
3
#
4
03
B
#
4
C
5
04
A
1
B
@
3