I have a range of cells containing empty cells and some not, arranged in a row and I need a formula that receives those values in a column, except the empty cells, below an example of what I need, adding that the said ranges are named "BlanksRange" and "NoBlanksRange"
Before posting my question, I already ran searches on the web and found this formula close to what I needed, but the ranges are from column to column and as explained in the question, I needed row by column, I tried to adapt it but was not succeeding, which is why I requested help on this site. Later I began to analyze the formula that I had downloaded and found that it was enough to change the terms of the formula "ADDRESS (num_lin; núm_col)", and it worked. Example Formula:
{=SE(LIN()-LIN(NoBlanks)+1>LINS(BlanksRange)-CONTAR.VAZIO(Blanks);"";INDIRETO(ENDEREÇO(MENOR((SE(Blanks<>"";LIN(Blanks);LIN()+LINS(Blanks)));LIN()-LIN(NoBlanks)+1);COL(Blanks);4)))}
Modified formula:
{=SE(LIN()-LIN(NoBlanks)+1>COLS(Blanks)-CONTAR.VAZIO(Blanks);"";INDIRETO(ENDEREÇO(LIN(Blanks);MENOR((SE(Blanks<>"";COL(Blanks);COL()+COLS(Blanks)));LIN()-LIN(NoBlanks)+1);4)))}
See the image:
