I have a very long list of data. Is there a way to quickly line up two rows?</SPAN>
example:</SPAN>
I import data into Excel 2007 and get this results:</SPAN>
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>
<TBODY>
</TBODY>I want this result:
<TBODY>
</TBODY>thank you!!! ![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
example:</SPAN>
I import data into Excel 2007 and get this results:</SPAN>
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>
A</SPAN></SPAN> | B</SPAN></SPAN> | C</SPAN></SPAN> | D</SPAN></SPAN> |
1</SPAN></SPAN> | 1</SPAN></SPAN> | 6</SPAN></SPAN> | ECMO OR TRACH</SPAN></SPAN> |
2</SPAN></SPAN> | 2</SPAN></SPAN> | 9</SPAN></SPAN> | TRACH W MV </SPAN></SPAN> |
3</SPAN></SPAN> | 6</SPAN></SPAN> | 10</SPAN></SPAN> | CRANIO W MAJOR </SPAN></SPAN> |
4</SPAN></SPAN> | 8</SPAN></SPAN> | 17</SPAN></SPAN> | CRANIOTOMY </SPAN></SPAN> |
5</SPAN></SPAN> | 9</SPAN></SPAN> | 22</SPAN></SPAN> | EXTRACRANIAL </SPAN></SPAN> |
6</SPAN></SPAN> | 10</SPAN></SPAN> | | |
7</SPAN></SPAN> | 12</SPAN></SPAN> | | |
8</SPAN></SPAN> | 14</SPAN></SPAN> | | |
9</SPAN></SPAN> | 17</SPAN></SPAN> | | |
10</SPAN></SPAN> | 22</SPAN></SPAN> | | |
<TBODY>
</TBODY>
A</SPAN></SPAN> | B</SPAN></SPAN> | C</SPAN></SPAN> | D</SPAN></SPAN> |
1</SPAN></SPAN> | 1</SPAN></SPAN> | | |
2</SPAN></SPAN> | 2</SPAN></SPAN> | | |
3</SPAN></SPAN> | 6</SPAN></SPAN> | 6</SPAN></SPAN> | ECMO OR TRACH</SPAN></SPAN> |
4</SPAN></SPAN> | 8</SPAN></SPAN> | | |
5</SPAN></SPAN> | 9</SPAN></SPAN> | 9</SPAN></SPAN> | TRACH W MV </SPAN></SPAN> |
6</SPAN></SPAN> | 10</SPAN></SPAN> | 10</SPAN></SPAN> | CRANIO W MAJOR </SPAN></SPAN> |
7</SPAN></SPAN> | 12</SPAN></SPAN> | | |
8</SPAN></SPAN> | 14</SPAN></SPAN> | | |
9</SPAN></SPAN> | 17</SPAN></SPAN> | 17</SPAN></SPAN> | CRANIOTOMY </SPAN></SPAN> |
10</SPAN></SPAN> | 22</SPAN></SPAN> | 22</SPAN></SPAN> | EXTRACRANIAL </SPAN></SPAN> |
<TBODY>
</TBODY>