Perfect thank-you. An elegant and scale-able solution as is the solution suggested by Bill Szysz below...
RachaelH Today, 02:04 AMPower Query. You have it in Excel 2016. It’s great for producing summary tables like this and sorting them to suit....
AliGW Yesterday, 10:27 PMMay I please request some assistance with some data? My music inventory spreadsheet has a column named Year of Release. If I know the release year of...
jdanniel Yesterday, 07:54 PMSolved elsewhere.thread closed...
Pecoflyer Yesterday, 03:27 PM
Create normalised tables using M code
Hi Bill this is an excellent solution that works just as well as the suggestion from horseyride below. Thanks for your assistance....
RachaelH Today, 02:06 AM