Convert data from long to wide format
Usage
long2wide(
data,
within = c(),
between = c(),
dv = "y",
id = "id",
sep = faux_options("sep")
)Examples
df_long <- sim_design(2, 2, long = TRUE)
long2wide(df_long, "A", "B")
#> id B1 W1a W1b
#> 1 S001 B1a 0.354805853 1.205232641
#> 2 S002 B1a -0.736256741 -1.728190638
#> 3 S003 B1a -0.191127604 -0.223844732
#> 4 S004 B1a 1.533401992 -1.415933695
#> 5 S005 B1a 1.077079654 1.737964417
#> 6 S006 B1a -0.323968403 0.440350420
#> 7 S007 B1a -1.077993839 -0.730138372
#> 8 S008 B1a -0.518376698 -0.486442154
#> 9 S009 B1a 0.589532982 0.470135337
#> 10 S010 B1a 1.111378217 0.554350186
#> 11 S011 B1a -0.131892211 0.376345430
#> 12 S012 B1a -0.060716168 -0.036138155
#> 13 S013 B1a 0.534865445 0.078991796
#> 14 S014 B1a -1.131748127 1.231294892
#> 15 S015 B1a -1.177845540 -0.843276665
#> 16 S016 B1a -1.047734340 0.776448380
#> 17 S017 B1a 0.008382988 1.104461697
#> 18 S018 B1a -0.028941719 0.757466991
#> 19 S019 B1a 0.084328459 1.159256127
#> 20 S020 B1a -0.796168884 1.005901992
#> 21 S021 B1a -0.454526530 -0.089624792
#> 22 S022 B1a -0.197664441 -1.139081354
#> 23 S023 B1a 0.286678677 0.394313374
#> 24 S024 B1a 1.420936184 -0.633347888
#> 25 S025 B1a 0.137837609 -0.010302375
#> 26 S026 B1a 0.802273118 -0.007535261
#> 27 S027 B1a -0.260274202 -0.933613538
#> 28 S028 B1a -1.042504729 -0.754508455
#> 29 S029 B1a 0.742766003 1.122973651
#> 30 S030 B1a -1.466731704 -0.543109164
#> 31 S031 B1a 1.128309919 0.052130536
#> 32 S032 B1a 0.761078502 -1.252727876
#> 33 S033 B1a 0.982505073 0.866230165
#> 34 S034 B1a 0.602119559 -1.697689072
#> 35 S035 B1a -1.072710350 -1.354164770
#> 36 S036 B1a 1.045917273 -0.482134415
#> 37 S037 B1a 0.307761982 0.306127434
#> 38 S038 B1a 0.720166488 0.894255516
#> 39 S039 B1a -1.666557844 1.562200074
#> 40 S040 B1a 0.809664088 -1.190435297
#> 41 S041 B1a -0.271853472 -1.174666604
#> 42 S042 B1a 0.929487785 0.633679755
#> 43 S043 B1a -0.959286996 -0.176664113
#> 44 S044 B1a 1.876732097 2.184584054
#> 45 S045 B1a 1.880395067 -1.932882577
#> 46 S046 B1a -0.459396050 0.459750245
#> 47 S047 B1a -1.493215262 1.093092409
#> 48 S048 B1a 1.497283387 -0.186227230
#> 49 S049 B1a -0.982757178 0.696957804
#> 50 S050 B1a -0.767425521 1.615449301
#> 51 S051 B1a 0.100361055 -0.904532280
#> 52 S052 B1a -2.486550994 0.041057461
#> 53 S053 B1a -0.354335905 2.644589330
#> 54 S054 B1a -1.932002129 0.243791927
#> 55 S055 B1a 0.807769875 -0.272762621
#> 56 S056 B1a 0.102685922 -0.335656963
#> 57 S057 B1a 0.395844081 0.532083084
#> 58 S058 B1a 0.004060876 -1.278827287
#> 59 S059 B1a -0.255964444 0.804007240
#> 60 S060 B1a -0.029411263 1.635190986
#> 61 S061 B1a 0.731055287 0.941505929
#> 62 S062 B1a -0.849408284 -0.428267117
#> 63 S063 B1a -0.048429976 -0.831291765
#> 64 S064 B1a 1.183969667 -1.835505787
#> 65 S065 B1a -0.756449567 -0.247254737
#> 66 S066 B1a 0.171794973 1.620299191
#> 67 S067 B1a 0.098118897 0.204919147
#> 68 S068 B1a 0.924887501 -0.114943125
#> 69 S069 B1a 0.687091453 0.018261737
#> 70 S070 B1a -0.112423404 -0.097085018
#> 71 S071 B1a 1.160815888 0.747928660
#> 72 S072 B1a 0.099379746 -0.041512887
#> 73 S073 B1a 0.941020723 0.896636603
#> 74 S074 B1a -0.553394114 -0.929552094
#> 75 S075 B1a -0.589874580 0.142105896
#> 76 S076 B1a 1.739054266 -0.114852164
#> 77 S077 B1a -1.642374038 0.759107465
#> 78 S078 B1a 1.808051237 0.419674049
#> 79 S079 B1a 0.743886755 1.215161664
#> 80 S080 B1a 0.039677312 -0.145555529
#> 81 S081 B1a -1.769502445 -1.481424522
#> 82 S082 B1a 0.617712630 0.307720180
#> 83 S083 B1a 1.468045886 -0.552015216
#> 84 S084 B1a 2.516149908 -0.755510885
#> 85 S085 B1a 0.972410893 0.246601975
#> 86 S086 B1a -2.386719088 -1.010770347
#> 87 S087 B1a -0.687855072 -1.498653722
#> 88 S088 B1a -0.046524393 -2.208946248
#> 89 S089 B1a -0.154887732 0.760948675
#> 90 S090 B1a -0.232825624 0.175084373
#> 91 S091 B1a -0.346737910 -1.000735865
#> 92 S092 B1a 0.170606758 -1.410589833
#> 93 S093 B1a 0.296794033 1.587359759
#> 94 S094 B1a 1.332685261 0.929427917
#> 95 S095 B1a 0.994018229 1.001155570
#> 96 S096 B1a -0.054473130 0.813186531
#> 97 S097 B1a -1.218764798 -0.762376728
#> 98 S098 B1a -1.237900653 1.357208187
#> 99 S099 B1a -0.596513248 -1.656681336
#> 100 S100 B1a 0.453972583 0.851423282
#> 101 S101 B1b 0.765722683 1.005081917
#> 102 S102 B1b -1.919846705 -0.035572504
#> 103 S103 B1b -0.238016645 -0.586071107
#> 104 S104 B1b 1.837201002 0.286195291
#> 105 S105 B1b -0.153343742 -0.504154011
#> 106 S106 B1b 0.277925600 0.695365150
#> 107 S107 B1b 0.288227063 1.245263008
#> 108 S108 B1b 0.270474748 1.035568441
#> 109 S109 B1b 0.275943908 1.043531994
#> 110 S110 B1b -2.097230865 -0.251160610
#> 111 S111 B1b 1.153738056 2.555189768
#> 112 S112 B1b -0.839665434 0.871816119
#> 113 S113 B1b 0.068005832 2.289776147
#> 114 S114 B1b -0.111410080 -0.337269348
#> 115 S115 B1b -0.916421768 -0.331656953
#> 116 S116 B1b 0.765901888 -1.109112973
#> 117 S117 B1b -0.754671070 1.151287602
#> 118 S118 B1b -0.399068298 -0.270984984
#> 119 S119 B1b 2.453044882 0.274722800
#> 120 S120 B1b 0.802424723 0.478368441
#> 121 S121 B1b 1.210010476 -0.751286974
#> 122 S122 B1b 0.231419684 0.715798901
#> 123 S123 B1b -0.462074508 1.408492065
#> 124 S124 B1b -0.160420006 1.653524401
#> 125 S125 B1b -0.605867636 -0.767840954
#> 126 S126 B1b -0.011731929 -0.559464522
#> 127 S127 B1b -1.707826798 -0.409418807
#> 128 S128 B1b 0.834115231 0.603464528
#> 129 S129 B1b 0.517059092 -1.585790186
#> 130 S130 B1b 1.118983398 -0.335351812
#> 131 S131 B1b 0.701539439 0.748814986
#> 132 S132 B1b -1.118493740 -0.472136915
#> 133 S133 B1b 0.142023525 0.951384650
#> 134 S134 B1b 1.232766051 -0.268612094
#> 135 S135 B1b 0.197253609 0.171486716
#> 136 S136 B1b -0.586116841 -1.167245975
#> 137 S137 B1b -0.573437339 0.476431948
#> 138 S138 B1b 0.046605067 -1.782305035
#> 139 S139 B1b -0.526862428 -0.932023716
#> 140 S140 B1b -0.038525928 -3.063267138
#> 141 S141 B1b 1.016945510 0.643192603
#> 142 S142 B1b -1.273435768 0.512271167
#> 143 S143 B1b 0.233045422 0.778053619
#> 144 S144 B1b -1.342969103 -1.126668433
#> 145 S145 B1b 0.297728644 -1.259158744
#> 146 S146 B1b -1.456311353 -0.247296058
#> 147 S147 B1b 0.669895999 0.120595720
#> 148 S148 B1b 0.510187128 -0.581833191
#> 149 S149 B1b -0.075653883 -2.058911649
#> 150 S150 B1b -0.726768138 -1.012213598
#> 151 S151 B1b -1.906112979 -1.595364779
#> 152 S152 B1b 0.044453092 0.330237141
#> 153 S153 B1b -1.723949958 -0.985003025
#> 154 S154 B1b -0.781220794 -0.307016588
#> 155 S155 B1b 2.657218789 -0.219110615
#> 156 S156 B1b 0.308486891 0.122951472
#> 157 S157 B1b -0.320263954 1.043455214
#> 158 S158 B1b 0.043763430 1.569034457
#> 159 S159 B1b -0.633816333 0.316707469
#> 160 S160 B1b -0.037613008 -0.221067010
#> 161 S161 B1b -1.657230574 -0.002489949
#> 162 S162 B1b -0.176565242 -0.264685688
#> 163 S163 B1b -1.068276138 -0.841939706
#> 164 S164 B1b 1.496371766 -0.532365384
#> 165 S165 B1b -0.365493371 -0.431983298
#> 166 S166 B1b 2.252517709 0.493289405
#> 167 S167 B1b -0.730005356 0.277330987
#> 168 S168 B1b 0.254092800 -1.306140970
#> 169 S169 B1b 1.358083758 0.064878098
#> 170 S170 B1b -0.117322913 0.566769249
#> 171 S171 B1b -0.861984745 0.152475252
#> 172 S172 B1b -0.079238832 -0.676267384
#> 173 S173 B1b -0.495838470 0.464710241
#> 174 S174 B1b 0.233608574 -0.521692590
#> 175 S175 B1b 2.097229139 1.241858698
#> 176 S176 B1b -0.567316061 -0.390981584
#> 177 S177 B1b 0.301931945 -1.133336098
#> 178 S178 B1b 0.837509730 -0.653592982
#> 179 S179 B1b -0.492896724 1.007253432
#> 180 S180 B1b -0.910371977 -1.344974179
#> 181 S181 B1b -0.200408043 -0.064900680
#> 182 S182 B1b 0.063138000 -2.553261265
#> 183 S183 B1b 1.174649155 0.672065422
#> 184 S184 B1b 0.909391834 0.406913934
#> 185 S185 B1b 0.844294032 0.337686357
#> 186 S186 B1b -1.010085408 0.303403599
#> 187 S187 B1b -0.732999415 0.263001263
#> 188 S188 B1b 0.163087269 1.203688953
#> 189 S189 B1b 0.186552589 0.515604608
#> 190 S190 B1b 0.152606985 -1.341104120
#> 191 S191 B1b -1.174084491 1.137486773
#> 192 S192 B1b 0.325661765 0.188543006
#> 193 S193 B1b 0.486120661 -1.990380651
#> 194 S194 B1b 0.630553304 0.580869008
#> 195 S195 B1b -0.146666013 -0.411745787
#> 196 S196 B1b 0.384445605 0.709995510
#> 197 S197 B1b 0.134621346 0.204547772
#> 198 S198 B1b 1.609847147 1.374154276
#> 199 S199 B1b -0.311337201 1.945939793
#> 200 S200 B1b -1.584790594 1.117770527