Forum Discussion
Help with spreadsheet. May be simple
HAve a spreadsheet attached that shows what I need. I need to do this on a larger scale and would like to know if there is a simple way to do it. Thanks in advance
1 Reply
Hi,
The easiest way if you have Excel 2010 or later is to use Power Query (Get&Transform in 2016) - query your source data, make the list from the seat range, expand it on rows and return query back to Excel sheet table.
Script generated with user interface only is in attached file, with adding a bit of coding it could be made shorter and more efficient.
