Forum Discussion
Solved
Vlookup to find multiple variations of a text string
Hi, first time post here so bear with me! I am trying to create a worksheet that displays a list of shift types with names of staff allocated that shift over the period of a week. I can do this ...
I liked the reference to the Bill Jelen podcast. I have yet to get around to using measures and DAX so perhaps this will encourage me to seek out new problems where I can use it!
Thanks for this, it certainly does what I want.
Is there a way to convert sheet 1 into the table (A1:C24) you created in Tabelle1. I ask because the format of sheet1 is fixed as it is?
Thanks.
That is the PQ part. Goto to the PQ editor to see the queries and steps.
To load the table into PQ I assigned a name to the table range (-> name manager),
- Wow, never heard of the PQ editor! Anyway found it and am looking at the steps you took and kind of understand how it works. Just need to apply it to my original sheet now! Once it's set up does it automatically change the pivot table if the source data changes? I'm asking because there was an error in the source data on sheet 1 and when I changed that the pivot table didn't reflect the change.
Thanks again!
