As to task #1 try the following:
For cell P2 and down:
Formula: copy to clipboard 
=IFERROR(INDIRECT(TEXT(AGGREGATE(15,6,ROW(A$3:A$8)*100+COLUMN(B$1:K$1)/(B$3:K$8<>""),ROWS(A$1:A1)),"R0C00"),)&"","")

For cell M2 and down:
Formula: copy to clipboard 
=CHAR(SUM(62,AGGREGATE(15,6,ROW(A$3:A$8)/(B$3:K$8<>""),ROWS(A$1:A1))))&RIGHT(TEXT(MOD(AGGREGATE(15,6,ROW(A$3:A$8)*100+COLUMN(B$1:K$1)/(B$3:K$8<>""),ROWS(A$1:A1))/100,1),".00"),2)-1

Note that these are regular formulas, just press enter to activate.
I don't have any ideas about task #2, however I'll look back later to see if someone else has resolved it.
Let us know if you have any questions.