Shift n rows in column to next column by a grouping variable
조회 수: 1 (최근 30일)
이전 댓글 표시
I wish to shift every 5 rows to the next column as shown below. I have two columns C1 and C2. I want to shift every 5 rows representing a group variable A2 to third columns and 5 rows of group variable A3 to fourth column. Please suggest how to shift n rows in one columns to next column by a increasing number.
My data looks like this-
C1 C2
A1 23
A1 55
A1 45
A1 55
A1 77
A2 56
A2 43
A2 12
A2 33
A2 55
A3 11
A3 22
A3 33
A3 44
A3 55
My desired output is -
C1 C2 C3 C4
A1 23 NA NA
A1 55 NA NA
A1 45 NA NA
A1 55 NA NA
A1 77 NA NA
A2 NA 56 NA
A2 NA 43 NA
A2 NA 12 NA
A2 NA 33 NA
A2 NA 55 NA
A3 NA NA 11
A3 NA NA 22
A3 NA NA 33
A3 NA NA 44
A3 NA NA 55
댓글 수: 0
채택된 답변
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Logical에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!