[Qgis-user] Excel Prep to how one line per location

[Frank van Baar]

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: qgis-user-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] Namens Sasa Sullivan
Verzonden: 03 November 2014 20:20
Aan: qgis-user at lists.osgeo.org
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141104/d3dab5f8/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ExcelExample.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 11755 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141104/d3dab5f8/attachment.xlsx>