I have a table that is laid out with date as the Row heading and then several optional columns and then several required columns. I need to dynamically link it to a table that is better laid out for data analysis.
Data comes in as:
Book1IJKLMNOPQRSTUV1Optional 1Optional 2Optional 3Optional...