MCreighton
New Member
- Joined
- Aug 30, 2022
- Messages
- 10
- Office Version
- 365
- Platform
- MacOS
I have a dynamic table populated from a variety of sources which is essentially structured as:
dates as column headers (dynamical expands as new dates are entered, object names as left-most column (these names are currently fixed but more may be added), and then numeric data showing how many objects for each date (includes blanks).
I need to be able to stack this data so it can be exported into an external web-site. The stack would need three columns:
The date taken from the existing table column headers, the name of the object, the number of objects on that date.
And it should only stack data where the number of objects is not blank for the date in question.
I understand the basic concepts of stacking but taking successive dates from the existing table column headers to use them as 'row headers' is beyond me at the moment.
Hopefully I've explained the problem properly, but I've attached an image to. give an idea of what I mean. Any help gratefully received.
Mike
dates as column headers (dynamical expands as new dates are entered, object names as left-most column (these names are currently fixed but more may be added), and then numeric data showing how many objects for each date (includes blanks).
I need to be able to stack this data so it can be exported into an external web-site. The stack would need three columns:
The date taken from the existing table column headers, the name of the object, the number of objects on that date.
And it should only stack data where the number of objects is not blank for the date in question.
I understand the basic concepts of stacking but taking successive dates from the existing table column headers to use them as 'row headers' is beyond me at the moment.
Hopefully I've explained the problem properly, but I've attached an image to. give an idea of what I mean. Any help gratefully received.
Mike