Stacking date from a dynamic table

[MCreighton]

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

 

[Fluff]

Can you post some sample data, including the current formula.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[MCreighton]

Can you post some sample data, including the current formula.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

I could but there is not a current formula since I have not attempted to create a solution (not knowing where to start) - so I'm not sure that sample data in a spreadsheet would be any more help than the image I've already uploaded. I will, of course, if it's a requirement but didn't want to waste time if it's not actually helpful.

 

[Fluff]

If you don't have a formula how does your "dynamic table" get populated?

 

[MCreighton]

How it gets populated is entirely irrelevant to the question. If it makes it easier, let’s assume it’s non-dynamic. It’s the partial transposition of the data combined with stacking which is the problem I have.

Cheers

 

[Fluff]

How it gets populated is entirely irrelevant to the question.

Not as far as I'm concerned.

 

[MCreighton]

Not as far as I'm concerned.

Sorry for the late reply, been out for the evening. I am clearly missing something important. Why is how the table is populated relevant to the question in your view?

 

[Fluff]

Because without that information I have no idea how to reference it.
It could be one single formula that spills, multiple formulae that spill, a formula that is dragged down/across or a mixture.
That is why I asked for some sample data that includes the existing formulae, also I have no wish to re-create data that you already have.

 

[MCreighton]

OK. Still don't see how that impacts my original question. Anyhow I have tried to create a mini-sheet from a small selection of the sheet from which I am trying to create a list and it would appear I just don't have enough processing power since excel simply freezes and is still frozen an hour later. I'm not surprised given the volume of data I am managing - hundreds of thousands of records collated from a dozen different input sources. Anyhow, thanks for looking. To simply matters I am going to close this thread, and open a new one with just a sample export of the data only. Since I can always programatically export the data this will then give a simple table that, hopefully, someone will be able to advise how to construct a stacked list. And that will solve my problem. Thanks again.
Mike

 

[Fluff]

Please do not start a new thread for this question. Just post the data here.