tianqingliu/xlW2L: Convert an Excel Wide Table to Long Data Frame

This function converts Execl Wide Table to Long Data Frame. The original Excel table is with identification columns, one key-name column and y-value columns. It removes y-value columns without headers or without any y-value contents, and removes identification columns without headers or without id-value in the first cell. It returns three objects: the original Excel table, cleaned Wide Data Frame, and Long Data Frame. If the original file is .csv type, all three objects returned are the original csv table.

install.packages("remotes")
remotes::install_github("tianqingliu/xlW2L")