How to Import Pivoted Excel Data in R: tidyxl, unpivotr

[@mallorykrumrei7338]

Thank you so much! This is exactly what I was looking for and couldn’t find anywhere else. You did a great job explaining, and I really appreciated the summarizing slide at the end comparing the different packages because that was something I was still unclear about.

[@haraldurkarlsson1147]

Some Excel files are a real challenge to deal with. I found the unheadr package to be helpful in combination with some of the tidyverse packages (tidyr). It also helps to know a little bit about regular expressions (regex).

[@ahmed007Jaber]

thank you for this. I have come across the two packages but never heard about unpivotr::rectify. Thank you for sharing. This is really helpful