November 8, 2019
I have created a table to monitor stock, we keep a comments column and i decided to try to create the report so that we didn't have to vlookup last weeks comments to this weeks new data export from our system (this is the link i followed )
I had a drop down box in a few columns, but every time I update it seems to duplicate all of the lines and its loosing the drop down box in the table. Is anyone able to help?
July 16, 2010
Welcome to our forum!
Power Query tables don't support data validation. The query owns the table and anything that goes in that table must come from Power Query. If you manually override the query table cells with something like data validation, it will get replaced upon refresh.
As for the duplicate lines, I'd say there is some error in your query...obviously :-). But I can't tell what it might be without seeing it, sorry.