Accurate, Focused Research on Law, Technology and Knowledge Discovery Since 2002

How to uncover Excel data only revealed by a drop-down menu

Online Journalism Blog: “Sometimes an organisation will publish a spreadsheet where only a part of the full data is shown when you select from a drop-down menu. In order to get all the data, you’d have to manually select each option, and then copy the results into a new spreadsheet. It’s not great. In this post, I’ll explain some tricks for finding out exactly where the full data is hidden, and  how to extract it without getting Repetitive Strain Injury. Here goes…”

Sorry, comments are closed for this post.