Shift n rows in column to next column by a grouping variable
Show older comments
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
Accepted Answer
More Answers (0)
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!