S
sashabaz
I have a table that collates a data from other sources (internal worksheets
or external). I need to create a formula that searches through the array for
non-blanks and showing these non-blanks with no spaces between them. Below
is an example of what I am trying to do.
Hidden Sheet:
Outsourcer - Discipline - Quality - Cost - Value
This has LOTS of blank spaces within and the reason I need to remove them is
that I am going to export the data to another program and need to tidy it up
before I can.
The formula should take ONLY the non blank cells and put them into the Main
Sheet which has the same comlumn headings in the same order.
or external). I need to create a formula that searches through the array for
non-blanks and showing these non-blanks with no spaces between them. Below
is an example of what I am trying to do.
Hidden Sheet:
Outsourcer - Discipline - Quality - Cost - Value
This has LOTS of blank spaces within and the reason I need to remove them is
that I am going to export the data to another program and need to tidy it up
before I can.
The formula should take ONLY the non blank cells and put them into the Main
Sheet which has the same comlumn headings in the same order.