Hi, first time poster, be gentle with me!
I have a table (called Raw) which I'd like to dump into a new table (called Working). Four of the fields are static and will be repeated each time. However there are 104 fields of data (each named by the date the sales are for) which I'd like to extract, using the name of the field as the value for a new field.
I've attached an example of the raw data, and how I'd like it to look in the new working table.
Is there any way I can do this by counting columns rather than using their names? This would be ideal, as I have to clean this sort of data all the time, so it would be good to be able to use the same code over various formats of raw data.
TIA!