So far I have gotten this far;
merged_data <- Mock_spreadsheet %>%
group_by(pt name
) %>%
summarize(notes_merge = paste(notes, collapse = ","), date = paste(date of contact
, collapse = ","))
However, this only works on the columns i need merged, but exludes columns where the info is the same( such as contact info ect).
Data looks kinda like this: I need for example Eva to be merged by status, notes and dates, everything else can be replaced since its the same... Hope this makes sense, I would really appreciate any help.
pt name contact # ins. Provider date of contact Referral ReferralName Status staff notes
1 eva malso 123.456.7890 cigna 1.2.21 RRRC Tyler BOV initiated KO pt called to ask about some services. Ins info provided. Billing Solutions contacted.
2 mark smith 234.567.8901 bcbs 1.2.21 DS Susie Car1 info KO Pt interested in some night sessions. Info provided. No ins. Collected.
3 john doe 345.678.9012 united 1.3.21 CP Jack LOL initiated SB pt interested in medicine. Ins info provided. Billing solutions contacted.
4 eva malso 123.456.7890 cigna 1.4.21 RRRC Tyler ASC intiated SB Deductible of $14. Met $21.34. company process initiated...