amirkharkongor
New Member
- Joined
- Nov 8, 2021
- Messages
- 12
- Office Version
- 2019
- 2016
- 2010
- Platform
- Windows
- Web
is there any solution / formula to re arrange the following example :
My sheet | ||||||||
name | age | gender | name | age | gender | name | age | gender |
aaa | 15 | M | bbb | 16 | M | ccc | 14 | F |
ddd | 13 | F | eee | 14 | M | fff | 17 | M |
Formula to rearrange in the following manner | ||||||||
name | age | gender | ||||||
aaa | 15 | M | ||||||
bbb | 16 | M | ||||||
ccc | 14 | F | ||||||
ddd | 13 | F | ||||||
eee | 14 | M | ||||||
fff | 17 | M |