CODEWITHSUNDEEP
excel
Scott
Scott

Reputation: 2760

Excel - Merge Multiple Columns Cells into a single Cell

I have an Excel spreadsheet in the usual fashion. That is to say, rows and columns. So if there are seven rows, each column has seven values. I want to take one of these columns and make it extend down across the whole spreadsheet. TRANSFORMATION (LOGIC) used to have seven values, now it has one. How do I do this? EDIT: By "down across", I mean the column should have just one cell.

enter image description here

Upvotes: 0

Views: 671

Answers (1)

Seplo
Seplo

Reputation: 136

In order to achieve the merging of your cells, select the desired cell range on your sheet and then you will click the "Merge" button found on the Home tab in Excel.

enter image description hereNote that if the content is already in the cells it will take the value from the first cell which has content in it already, so best to copy your values and such out first if you would like to preserve them.

Upvotes: 1

Related Questions