williamscheidt
New Member
- Joined
- Dec 7, 2013
- Messages
- 31
Hi,
I'm an Excel beginner running Excel for Mac 2011. I'm in need of assistance in combining data from pairs of subsequent rows into one row, as in the simplified example below. In reality I have 303 pairs of rows (606 total rows) with 14 columns in each.
Thank you in advance for your time and expertise!
Bill
FROM:
<!--StartFragment--> <colgroup><col width="65" span="3" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
TO:
<!--StartFragment--> <colgroup><col width="65" span="6" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
I'm an Excel beginner running Excel for Mac 2011. I'm in need of assistance in combining data from pairs of subsequent rows into one row, as in the simplified example below. In reality I have 303 pairs of rows (606 total rows) with 14 columns in each.
Thank you in advance for your time and expertise!
Bill
FROM:
1 | 2 | 3 |
4 | 5 | 6 |
7 | 8 | 9 |
10 | 11 | 12 |
<!--StartFragment--> <colgroup><col width="65" span="3" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
TO:
1 | 2 | 3 | 4 | 5 | 6 |
7 | 8 | 9 | 10 | 11 | 12 |
<!--StartFragment--> <colgroup><col width="65" span="6" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>