I have a number of years of census files in dataframe or tibbles. Each year consists of rows as location (e.g. County code) and the MANY columns are various census metrics: Age, Male, Female, etc.
I want to unpivot the data column names to become values in a new column ("metric") and have the actual data value for that Count-Metric intersect go to a field called "Value".
As I read "Gathering" it doesn't appear to meet my needs - as judged by my newbie brain.
But each file is MANY columns. So help for a newbie on the simple task and then the recursive approach to many columns is much appreciated.
