Hi,
I am trying to merge the data from 4 different cells into one blank cell in the same worksheet and then carry this down for each row in the table.
Here are the conditions:
- The data to merge will be dates with labels (eg. Date 1 - 1/20/2009, Date 2 - 6/5/2009 etc.)
- Some, or all cells in a row may be empty
- Merged cell will only show data that is visible (blank cells are omitted)
- If the data resides in columns A-D and A,C and D are populated the result would show Date 1, Date 3 and Date 4 each with their respective label
The stakeholder for this only wants the data visible to be shown and each date will have a label to identify it based on the column header of the column it came from. I have managed to use the CONCATENATE and TEST functions to show the results from every cell but get blank cells showing up as 1/01/1900.
I know that I can write a series of IF statements, but the whole thing would be quite large, complex and exceed the 7 nested statements. I know that there must be a simpler way to execute this, but it is escaping me.
If anyone could provide some assistance on this, it would be greatly appreciated
Thanks,
Jeff
Bookmarks