smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
All cells in Sheet1 row3 contains some text or values (70 elements in total) but I need to copy/transpose contents only from every second cell from Sheet1 row3 into Sheet4 column B, starting from B4 cell (B4:B38, first 35 elements).
Than again from Sheet1 row3 same action again, but now for the last 35 cells/elements into Sheet4 column H (H4:H38).
I would like formula(s), not macro.
Example.
Sheet1 (row 3, columns A-BR)
<tbody>
</tbody>
Sheet4 (after copy/transpose)
<tbody>
</tbody>Sheet1 (row3, columns BS-EJ)
<tbody>
</tbody>
Sheet4
<tbody>
</tbody>
All cells in Sheet1 row3 contains some text or values (70 elements in total) but I need to copy/transpose contents only from every second cell from Sheet1 row3 into Sheet4 column B, starting from B4 cell (B4:B38, first 35 elements).
Than again from Sheet1 row3 same action again, but now for the last 35 cells/elements into Sheet4 column H (H4:H38).
I would like formula(s), not macro.
Example.
Sheet1 (row 3, columns A-BR)
A | B | C | D | E | F | G | H | |
1 | ||||||||
2 | ||||||||
3 | shop | mrexcel | pattern | home | 4.76 | salary | storm | .... |
<tbody>
</tbody>
Sheet4 (after copy/transpose)
B | |
1 | |
2 | |
3 | |
4 | mrexcel |
5 | home |
6 | salary |
7 | ..... |
<tbody>
</tbody>
BS | BT | BU | BV | BW | BX | BY | ... | |
1 | ||||||||
2 | ||||||||
3 | city | value | airport | 7.28 | budget | 2.15 | eclipse | ... |
<tbody>
</tbody>
Sheet4
H | |
1 | |
2 | |
3 | |
4 | value |
5 | 7.28 |
6 | 2.15 |
7 | ..... |
<tbody>
</tbody>