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 |
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.
PeterBartholomew1 That's great. How can I create this macro myself?