First of all thank you for your attempt to help me, I apologize if I was not able to be clear


1) I mean Colum A A11÷A55, column B B11÷B55...up to column AV AV11÷AV55 (by variable column height I meant that they can contain a variable amount of data )


2) each of the 6 numbers of the matrix 1÷77 that is found among the 48 columns should be transposed starting from AX3...so for example in the range A11÷A55 only the numbers 1 and 27 of the matrix are found and they should be transposed into AX3 AY3, in the range B11÷B55 there are 4 values ​​and they should be transposed starting from AX4 towards the right in an orderly fashion and so on until the last column - in my sheet the equal values ​​between the matrix and those in the data area A11 ÷ AV55 are highlighted with equal colors-.

TranspFV_.jpg


3) I think it's clarified in the previous point


I am working with Excel 2021




Thanks again
I hope I have clarified my request