Forum Discussion
Merge two cells one below the other
I have a excel sheet with data like below: Sheet attached. I want to merge cells under Data Column corresponding to the same servername in one cell. For example I want, Server1Data1 and Serv...
Data is like below:
| ServerName | Data |
| Server1 | Server1 Data |
| Server1 Data | |
| Server2 | Server2Data |
| Server2Data | |
| Server2Data |
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)?
