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.12044121 1.360982601
#> 2 S002 B1a 2.21277768 -1.338165580
#> 3 S003 B1a -0.43659252 0.367549189
#> 4 S004 B1a 0.04889179 -1.329208582
#> 5 S005 B1a -0.63724934 -1.375367504
#> 6 S006 B1a -0.31258070 -1.026399443
#> 7 S007 B1a 1.25246753 0.108212165
#> 8 S008 B1a -1.07111579 0.286077498
#> 9 S009 B1a -0.49327403 -0.150771857
#> 10 S010 B1a -0.27112507 0.242916247
#> 11 S011 B1a -0.16307845 1.861034441
#> 12 S012 B1a -0.25578601 0.030554097
#> 13 S013 B1a 1.16164397 -0.213670280
#> 14 S014 B1a 0.07615922 1.060739207
#> 15 S015 B1a -0.67270787 -0.359266472
#> 16 S016 B1a -0.25702632 0.490185360
#> 17 S017 B1a -0.76618039 2.223751803
#> 18 S018 B1a 0.69904588 0.438443188
#> 19 S019 B1a -0.01572135 0.229604528
#> 20 S020 B1a 0.42934021 0.681828014
#> 21 S021 B1a -2.29160328 0.657909971
#> 22 S022 B1a 1.58815889 -0.564006947
#> 23 S023 B1a 1.58413690 -0.658896168
#> 24 S024 B1a -0.46371350 -0.883460257
#> 25 S025 B1a -0.26159144 0.563453282
#> 26 S026 B1a 0.60049190 0.735893427
#> 27 S027 B1a 0.12649895 1.021294889
#> 28 S028 B1a 0.48195485 -1.319630434
#> 29 S029 B1a -1.64511459 -2.132052693
#> 30 S030 B1a 0.49519670 0.279953366
#> 31 S031 B1a -0.99218157 0.135759353
#> 32 S032 B1a 0.94971872 -1.772955025
#> 33 S033 B1a -0.83737610 -1.157864839
#> 34 S034 B1a -0.23919669 -2.573827434
#> 35 S035 B1a 0.18965850 0.025684719
#> 36 S036 B1a -0.14863041 -0.373922460
#> 37 S037 B1a 0.20683557 -0.106181382
#> 38 S038 B1a -1.28702978 0.950883043
#> 39 S039 B1a 2.81940701 -0.229954149
#> 40 S040 B1a -0.76599443 -2.657569860
#> 41 S041 B1a 1.80348759 -0.425861360
#> 42 S042 B1a -1.46144134 -1.834446336
#> 43 S043 B1a -2.03168892 0.269468045
#> 44 S044 B1a -1.02120227 1.095533510
#> 45 S045 B1a 0.54658479 -0.006297506
#> 46 S046 B1a -0.73150369 0.443540824
#> 47 S047 B1a -0.26074250 0.608478135
#> 48 S048 B1a -0.96791818 0.059662702
#> 49 S049 B1a 0.52478984 1.739437151
#> 50 S050 B1a 0.91087017 1.678572166
#> 51 S051 B1a 0.05782859 -1.964809312
#> 52 S052 B1a 0.62838480 1.832321438
#> 53 S053 B1a -0.22517185 -0.103713376
#> 54 S054 B1a 0.23488433 -0.908860345
#> 55 S055 B1a -0.09773595 -0.892189283
#> 56 S056 B1a 0.78916980 0.152147982
#> 57 S057 B1a -1.42793895 1.321645928
#> 58 S058 B1a -0.31119610 0.172418681
#> 59 S059 B1a 0.93403786 0.667411532
#> 60 S060 B1a -0.48405498 0.642019403
#> 61 S061 B1a 1.86314695 1.196921262
#> 62 S062 B1a 0.80782348 2.337663379
#> 63 S063 B1a 1.17691635 -0.208117800
#> 64 S064 B1a 0.86228324 -0.281734342
#> 65 S065 B1a 2.28153220 -0.820954176
#> 66 S066 B1a 0.47208021 -1.020317269
#> 67 S067 B1a 2.83246848 1.041570498
#> 68 S068 B1a 0.98660686 0.052774529
#> 69 S069 B1a 0.51802112 0.374077734
#> 70 S070 B1a -0.60367767 -0.137510583
#> 71 S071 B1a 1.84330550 0.132833910
#> 72 S072 B1a 0.46905901 -0.098014875
#> 73 S073 B1a 0.99442079 -0.526603325
#> 74 S074 B1a -0.34291406 0.500506373
#> 75 S075 B1a -0.91381806 -0.547256120
#> 76 S076 B1a -1.03336117 0.181055265
#> 77 S077 B1a -1.50028943 -1.631345497
#> 78 S078 B1a 0.59722707 -0.780543626
#> 79 S079 B1a -0.07797303 1.097695617
#> 80 S080 B1a -1.02320304 0.305178847
#> 81 S081 B1a -0.94566126 -0.360536326
#> 82 S082 B1a -0.79258345 -0.229379212
#> 83 S083 B1a 1.61961441 -0.596642128
#> 84 S084 B1a 0.19876103 -0.204887271
#> 85 S085 B1a -2.35519480 -0.852406306
#> 86 S086 B1a 1.05118235 0.066228167
#> 87 S087 B1a -0.55558115 -0.554416039
#> 88 S088 B1a -0.04127360 1.096765826
#> 89 S089 B1a 0.32229296 0.256245460
#> 90 S090 B1a -0.83893583 -0.129945517
#> 91 S091 B1a -0.04357596 -0.724453789
#> 92 S092 B1a -1.48819875 0.741177431
#> 93 S093 B1a -0.47180976 0.407319554
#> 94 S094 B1a -1.30496933 -1.192219294
#> 95 S095 B1a -0.45885628 -0.987205616
#> 96 S096 B1a -0.69207562 -0.146693649
#> 97 S097 B1a -0.12888984 0.505714285
#> 98 S098 B1a -0.40241208 -0.914465608
#> 99 S099 B1a -1.01549189 -0.798129624
#> 100 S100 B1a 1.26174947 1.030166761
#> 101 S101 B1b -0.53037723 2.108017019
#> 102 S102 B1b -0.71625328 -1.781029531
#> 103 S103 B1b -0.47929092 -1.598590379
#> 104 S104 B1b 0.03592650 -0.215153224
#> 105 S105 B1b 0.50980096 -2.986318522
#> 106 S106 B1b -0.03575761 -0.041968678
#> 107 S107 B1b 0.98635329 -0.596492419
#> 108 S108 B1b -0.41658995 1.261644813
#> 109 S109 B1b -0.23282081 -0.530525845
#> 110 S110 B1b -1.12110808 -2.437984279
#> 111 S111 B1b -0.28758051 -1.614097251
#> 112 S112 B1b 0.35911058 -1.194997385
#> 113 S113 B1b -1.24320689 0.115364752
#> 114 S114 B1b -0.17434503 3.250559601
#> 115 S115 B1b -1.20624941 -1.122979688
#> 116 S116 B1b -1.76662766 0.052746032
#> 117 S117 B1b 0.04902885 -0.091993723
#> 118 S118 B1b -0.77063793 0.220026188
#> 119 S119 B1b 0.25671909 -1.275358509
#> 120 S120 B1b -0.02554863 0.949421121
#> 121 S121 B1b -0.23751447 -0.248157476
#> 122 S122 B1b -0.88573876 -0.004112341
#> 123 S123 B1b -0.70344190 0.405299807
#> 124 S124 B1b 0.46966700 0.165535997
#> 125 S125 B1b -0.72154750 0.119533221
#> 126 S126 B1b -0.46175539 -1.831523371
#> 127 S127 B1b -1.64774669 1.277421222
#> 128 S128 B1b 1.67889459 0.066249399
#> 129 S129 B1b 0.36758690 -0.991105065
#> 130 S130 B1b 0.95975381 -0.404153013
#> 131 S131 B1b 2.00575366 0.429018101
#> 132 S132 B1b 0.13236209 -0.565554701
#> 133 S133 B1b -0.28916250 -0.099173087
#> 134 S134 B1b -0.21880875 0.211489070
#> 135 S135 B1b -1.06072293 0.119588275
#> 136 S136 B1b -0.21351522 -2.027301544
#> 137 S137 B1b -0.54907297 0.831992870
#> 138 S138 B1b -0.54832889 -1.606043854
#> 139 S139 B1b -0.31082432 -1.689779826
#> 140 S140 B1b 0.13371491 0.738309158
#> 141 S141 B1b -0.70681873 0.095195030
#> 142 S142 B1b -0.47100311 -0.346620467
#> 143 S143 B1b 1.20174020 1.327775778
#> 144 S144 B1b -1.47911407 -0.094717559
#> 145 S145 B1b -0.59839006 0.300947182
#> 146 S146 B1b -1.34037147 0.480288058
#> 147 S147 B1b -0.37198894 0.122507002
#> 148 S148 B1b 1.04928440 -0.748413067
#> 149 S149 B1b -0.27538192 -0.745744349
#> 150 S150 B1b -0.55431480 -0.735396729
#> 151 S151 B1b -0.54155522 -0.077071949
#> 152 S152 B1b 1.17747763 -0.084034846
#> 153 S153 B1b -0.56079705 -0.508672507
#> 154 S154 B1b 0.58082912 1.112111774
#> 155 S155 B1b -0.85832462 0.356335713
#> 156 S156 B1b -0.65264188 -0.826082381
#> 157 S157 B1b -0.32891560 1.520441461
#> 158 S158 B1b 1.32571904 1.797568223
#> 159 S159 B1b -0.95707491 0.802457993
#> 160 S160 B1b 0.56620955 -0.773912575
#> 161 S161 B1b 1.11120830 -0.218047289
#> 162 S162 B1b 0.55086354 0.237318224
#> 163 S163 B1b 0.37367279 0.314853717
#> 164 S164 B1b 1.18546833 0.013164627
#> 165 S165 B1b 1.71595418 -0.017992481
#> 166 S166 B1b 0.21056409 -0.653100594
#> 167 S167 B1b 0.39388952 0.493131797
#> 168 S168 B1b -0.50559719 0.319179194
#> 169 S169 B1b 0.80498022 0.196977075
#> 170 S170 B1b -0.15287315 -1.022743076
#> 171 S171 B1b 2.54451145 1.258061755
#> 172 S172 B1b -1.86967004 0.039584401
#> 173 S173 B1b -0.09898147 -1.225466310
#> 174 S174 B1b 0.04003203 -0.289543243
#> 175 S175 B1b 0.26890106 -1.718177072
#> 176 S176 B1b 0.08784574 0.058659256
#> 177 S177 B1b 0.81385782 -0.955090445
#> 178 S178 B1b 0.25121607 -0.426002665
#> 179 S179 B1b -0.99241891 1.949545920
#> 180 S180 B1b 0.21403998 0.177145073
#> 181 S181 B1b -0.44426873 0.978288816
#> 182 S182 B1b -1.74007684 0.096575233
#> 183 S183 B1b 0.01877673 -1.318730172
#> 184 S184 B1b 0.33195820 0.415408990
#> 185 S185 B1b -0.90139850 -0.344256265
#> 186 S186 B1b 0.66574437 -0.727141725
#> 187 S187 B1b 0.67489643 0.640393941
#> 188 S188 B1b 0.14480553 -1.562274430
#> 189 S189 B1b 0.88922783 -0.010684509
#> 190 S190 B1b 0.20103953 -0.806677697
#> 191 S191 B1b 0.08037941 -1.665732113
#> 192 S192 B1b -0.31329771 -1.009127392
#> 193 S193 B1b -0.44031324 -1.255668053
#> 194 S194 B1b -0.44210169 0.638606491
#> 195 S195 B1b 0.48250192 -1.472299252
#> 196 S196 B1b 2.72870386 -0.521282763
#> 197 S197 B1b -1.75408722 1.024468700
#> 198 S198 B1b -0.48238539 1.133217836
#> 199 S199 B1b 0.05486870 -0.539624382
#> 200 S200 B1b -1.06470570 1.049129368