praveenpatel421983
New Member
- Joined
- Aug 17, 2017
- Messages
- 41
Hi,
I have a excel which has 1000 of rows but every 3 rows belongs to one category. I want to transpose into 3 columns. I searched through various data but couldn't find the right looping. Please help. Number of columns for each category is not same.
<tbody>
</tbody>
It should come like below format
<tbody>
</tbody>
Can anyone please help?
thanks
Praveen Patelappa
I have a excel which has 1000 of rows but every 3 rows belongs to one category. I want to transpose into 3 columns. I searched through various data but couldn't find the right looping. Please help. Number of columns for each category is not same.
Category 1 | Day 1 | a | b | c | d | e | f | g | h |
Day 2 | i | j | k | l | m | n | o | p | |
Day 3 | q | r | s | t | u | v | w | x | |
Category 2 | Day 1 | a | b | c | d | e | f | ||
Day 2 | g | h | i | j | k | l | |||
Day 3 | m | n | o | p | q | r | |||
Category 3 | Day 1 | a | b | c | d | e | f | g | |
Day 2 | h | i | j | k | l | m | n | ||
Day 3 | o | p | q | r | s | t | u | ||
Category 4 | Day 1 | a | b | c | d | e | |||
Day 2 | f | g | h | i | j | ||||
Day 3 | k | l | m | n | o |
<tbody>
</tbody>
It should come like below format
Day 1 | Day 2 | Day3 | |
Category 1 | a | i | q |
b | j | r | |
c | k | s | |
d | l | t | |
e | m | u | |
f | n | v | |
g | o | w | |
h | p | x | |
Category 2 | a | g | m |
b | h | n | |
c | i | o | |
d | j | p | |
e | k | q | |
f | l | r | |
Category 3 | a | h | o |
b | i | p | |
c | j | q | |
d | k | r | |
e | l | s | |
f | m | t | |
g | n | u | |
Category 4 | a | f | k |
b | g | l | |
c | h | m | |
d | i | n | |
e | j | o |
<tbody>
</tbody>
Can anyone please help?
thanks
Praveen Patelappa