Hi Sasa,
Would use excel to do the manipulation: · Add 2 columns to original sheet with rownumber & number of locations · Create second sheet that recreates a new list based on lookups/index formulas · Copy second sheet as values into CSV file Have created simple example file (attached). Hope it works. Frank Van: [email protected] [mailto:[email protected]] Namens Sasa Sullivan Verzonden: 03 November 2014 20:20 Aan: [email protected] Onderwerp: [Qgis-user] Excel Prep to how one line per location Hi All, I need to prep an Excel spreadsheet. Thousands of names and each name with multiple locations (some with as few as 3 and others with over 30 locations). Is there a way to make a line item for the name (which is only listed once initially) based on each location? So If I have Bob Smith row with columns that show his 12 locations can I do something to automate my spreadsheet to show Bob Smith with each location on a separate line? There are also other columns that need to be duplicated but those would remain the same with each line item, only the location would be made a new line item. Thanks much in advance Best Regards, Sasa
ExcelExample.xlsx
Description: MS-Excel 2007 spreadsheet
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
