Jun 08 2021 05:50 AM - edited Jun 15 2021 01:42 AM
I need to populate the headers listed from columns J to R against the space references in column G. So for example where column J Sit to Stand is Yes, i need that header value i.e. Sit to Stand to be populated in cell I5.
Again for that same space of "E01", row Cell G5 where it also has yes against monitor column L, i need cell I6 to be populated with the header i.e. Monitor.
Can anyone help with this?
Jun 08 2021 06:20 AM - edited Jun 08 2021 06:21 AM
You need, I think, to give a bit more information about how the data are arranged here:
At the very least, though, if you expect to use some logic in doing this, you'll need to explain things a lot more completely in terms of the relationships between the various components--individual columns and rows--as well as whole contiguous areas. Otherwise you're in effect blind-folding the people from whom you are requesting help.
Jun 08 2021 06:45 AM - edited Jun 15 2021 01:42 AM
Jun 08 2021 07:42 AM
You still have a long way to go to fully explain the logic behind the data.
For example:
The examples you added in column I confirmed what was already pretty clear. But you still haven't explained how one can get there from the data. There is so much redundancy in the rows with the yellow column headings that I can't make sense of them. A good database design would NOT have repeating rows for the same individual/office. But it certainly looks as if that's what yours does.
In other words, you already have the data for individual 42/E01 in the first row. It's laid out horizontally; why does it need to be vertical? What are you doing that can't be accomplished by making this spreadsheet 1/9th the size? Eliminate the redundancies.