2 votes1 comment · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →Frederic LE GUEN - MVP commented
For instance, imagine you have a column with the country name and sometimes, in function of the language, the country name is not the same.
So, you have a table with 2 columns, one with all the country name you can have and a seconde one with the conversion.
You can have
Germany Germany (for English speakers)
Deutschland Germany (for German speakers)
Allemagne Germany (for French speakers)
Alemania Germany (for Spanish speakers)
So, if you merge 2 query to return the result of the conversion, you will have 2 columns and the 3 steps to remove, reorder and rename the column.
That's the perfect exemple to explain you why this new feature is neededFrederic LE GUEN - MVP shared this idea ·
227 votes19 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Thanks for logging this suggestion. Yes, this could be quite useful. Others that’re interested in this, please do log your votes so we’ll prioritize this work appropriately.
Lead Program Manager
128 votes15 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.
John [MS XL]