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 Server1Data2 to be merged and appear in one cell.
Similarly I want to do data related to Server2 and so on.
Please advise, how to achieve this?
10 Replies
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?
- 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.
