hello everyone, thanks in advance to read below
I'm having problem trying to not multiple recreate some rows of an original table when I want to tag them with a specific item to pivot over it.
Problem is that currently when I’d like clustery the original table with multiple area code for example (control 1 apply good for either Living room, ******* and Bathroom) I need to physically multiply number of rows. Problem more is that I have the original table in one sheet (with fixed number of controls) and I had to copy this one in another sheet to “play” with my pivot.
Any idea how to get an easier analysis to be applied to get a pivot showing up the set of items available for each control (*******/living room and all other part of a house) without all the time copying each control row to associate a different element of the house ?
Attached an example, thank you!
p.s. how to attach a file ?
I'm having problem trying to not multiple recreate some rows of an original table when I want to tag them with a specific item to pivot over it.
Problem is that currently when I’d like clustery the original table with multiple area code for example (control 1 apply good for either Living room, ******* and Bathroom) I need to physically multiply number of rows. Problem more is that I have the original table in one sheet (with fixed number of controls) and I had to copy this one in another sheet to “play” with my pivot.
Any idea how to get an easier analysis to be applied to get a pivot showing up the set of items available for each control (*******/living room and all other part of a house) without all the time copying each control row to associate a different element of the house ?
Attached an example, thank you!
p.s. how to attach a file ?