I have a row that is 400 columns wide with values sporadically thrown around in it. Majority of the values are blanks. Is there a way, without using visual basic, to put these nicely into a single column without blanks, using formulas only? There will never be more than 50 non-blank values, thus no more than 50 cells with formulas. I attached a sample file so it's a bit easier to understand what I am after. Thank you!
Horizontal to Vertical Example.xlsx