Forum Discussion
Merge two cells one below the other
Data is like below:
| ServerName | Data |
| Server1 | Server1 Data |
| Server1 Data | |
| Server2 | Server2Data |
| Server2Data | |
| Server2Data |
I there anything useful you can pick out of the attached?
I misread your post originally and thought you were trying to create merged cells as opposed to merging the content of multiple cells to a single cell.
No I did not get it. Can you explain please?
The file contains a macro that copies the content of cells from a named range on sheet 'Source' and writes it back the sheet 'Formatted' in roughly the format you requested.
The button 'Copy server data' runs the macro whilst 'Clear data' clears the content to allow you to develop the macro and re-import the data to test it.
- By all means, don’t merge unless it is the heading of a report. For data, never merge!
Twifoo I want to merge the data pertaining to the same server. Like if I am manually entering the information I can hit Alt+Enter to enter text on a new line in the same cell.
However this is a output from a script and I just want to keep the data related to each server in a single cell as opposed to many cells. I hope I am able to clarify.
What do you think of conditional formatting (provided one keeps the range of application tidy)?
