0

Hi need help transposing based on a variable (clm_no in example below)

I have a dataset that looks like:

 ID    DX   CLM_NO  DATE  
  2   F11    56     062021   
  4   F11    22     042022    
  4   F12    22     042022  
  4   F13    22     042022  
  7   F12    67     102021  
  7   F13    69     112021

I need it to look like this:

ID DX1 DX2 DX3 CLM_NO DATE  
2  F11  -   -   56    062021  
4  F11  F12 F13 22    042022  
7  F12  -   -   67    102021  
7  f13  -   -   69    112021

TIA!

Phil
  • 7,287
  • 3
  • 36
  • 66
Samantha Soprano
  • 1
  • 1
  • Try with `pivot_wider` `df1 %>% mutate(cn = str_c('DX', rowid(ID))) %>% pivot_wider(names_from = cn, values_from = DX)` – akrun Sep 27 '22 at 19:53

0 Answers0