This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
O.k. - so I think I have a dyanmic solution - but it's not pretty - could you post what you posted as an image as a .yxdb or .xlsx file? basically I can see a granular dynamic table with the magic of batch macro and render and then recreating that as a larger table.
also - can you confirm that non-zero values/a.k.a. red x can occur in any column?
This would be my start - obviously the problems are - 1) we want individual cells not groups of them with the same vales. 2) how to join them. Developing solutions for 1) - 2) will require some summarize and some join tools.
Sure - but keep in mind that it still will need some work to get your data as you want. As I see it - you'll have to add an outer batch macro column and then the summarize/union and summarize horizontal for the final columns will do their work.