Hello there,
I have a table that has the following data:
State City Location Neighborhood Tables Antioquia Medellín Puesto # 2 Comuna 1 33 Antioquia Bello Another Puesto Comuna 2 10
As you can see, there's a table named "Tables" which means the amount of positions inside a neighborhood. The first one has 33. Therefore, I need to find a way to multiply the amount of rows of the first one 32 times, so I end up with 33 total rows for the first row. AND replace or add a new column with the number of the table. Like this:
State City Location Neighborhood Tables Table # Antioquia Medellín Puesto # 2 Comuna 1 33 1 Antioquia Medellín Puesto # 2 Comuna 1 33 2 Antioquia Medellín Puesto # 2 Comuna 1 33 3 Antioquia Medellín Puesto # 2 Comuna 1 33 .... 33 Antioquia Bello Another Puesto Comuna 2 10 1 Antioquia Bello Another Puesto Comuna 2 10 2 Antioquia Bello Another Puesto Comuna 2 10 .... 10
Any advise?
I have attached a spreadsheet containing the original data. It does not contain any sensitive information.
Bookmarks