I have a spreadsheet with 20 year time series data for 100 firms. The names of the 100 firms are in the first column, followed by each column containing values for a particular year (21 columns).
I would like to replace the values in each column with the assigned decile distribution for each firm in that particular year. How would I go about doing this in R?