ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to merge rows? (https://www.excelbanter.com/excel-discussion-misc-queries/77978-how-merge-rows.html)

kiever1

How to merge rows?
 
I need merge rows. How to merge rows?

Gecko

How to merge rows?
 
Select the rows you want to merge & click the merge icon.

Otherwise, select the rows Format Cells Alignment Merge Cells

"kiever1" wrote:

I need merge rows. How to merge rows?


kiever1

How to merge rows?
 

Select the rows you want to merge & click the merge icon.
Otherwise, select the rows Format Cells Alignment Merge Cells


Thank you for answer, but
It is merge cells, but I need merge rows such as

This is I have:

A B
C
|---|-------------------------|---------------------|------------------------------|
| 1 | | B1 |
C1 |
|---| A1
|---------------------|------------------------------|
| 2 | | B2 |
C2 |
|---| |---------------------|-----------------
------------|
| 3 | | B3 |
C3 |
|---|-------------------------|---------------------|------------------------------|


This is I need:

A B
C
|---|-------------------------|---------------------|------------------------------|
| 1 | | B1 |
C1 |
| | A1 | |
|
| | | OldB2 |
OldC2 |
| | | |
|
| | | OldB3 |
OldC3 |
|---|-------------------------|---------------------|------------------------------|

kiever1

How to merge rows?
 
Select the rows you want to merge & click the merge icon.
Otherwise, select the rows Format Cells Alignment Merge Cells


Thank you for answer, but
It is merge cells, but I need merge rows such as

This is I have:

A B

|---|-------------------------|---------------------|
| 1 | | B1 |
|---| A1 |---------------------|
| 2 | | B2 |
|---| |---------------------|
| 3 | | B3 |
|---|-------------------------|---------------------|


This is I need:

A B

|---|-------------------------|---------------------|
| 1 | | B1 |
| | A1 | |
| | | OldB2 |
| | | |
| | | OldB3 |
|---|-------------------------|---------------------|


All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com