Hello everyone,
I am using Microsoft Excel 2007.
How can I return non-blank cells from a row section to another row section on the same row with formulas?
From Column B to Column H I would like to have the non-blank cells all listed one after one.
From Column I to Column O contains the data to be listed.
And each row has its own set of data to be listed.
The attached excel file simulates the the expected output.
I have been looking for the relevant information online but after a lot of testings all the existing similar solutions do not seem to work for me.
I am not sure about the reason but I guess maybe it is because the existing formulas available online return non-blank cells from a column section to a column section rather than from a row section to a row section.
Thanks a lot,
Lawrence
Bookmarks