Organización de datos.

%3CLINGO-SUB%20id%3D%22lingo-sub-1481106%22%20slang%3D%22es-ES%22%3EOrganization%20of%20data.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481106%22%20slang%3D%22es-ES%22%3EI%20have%20a%20database%20with%20more%20than%201000%20rows%20e%20with%2015%20columns.%20All%20data%20are%20integers%20between%201%20and%20100%2C%20more%20accurate%20to%20organize%20all%20of%20them%2C%20in%20their%20corresponding%20rows%2C%20from%20lowest%20to%20highest.%20How%20can%20I%20do%20it%3F%20By%20columns%2C%20I%20know%20it's%20very%20simple%2C%20more%20like%20doing%20it%20by%20rows%3F%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Thank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1481106%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1483746%22%20slang%3D%22en-US%22%3ERe%3A%20Organizaci%C3%B3n%20de%20datos.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483746%22%20slang%3D%22en-US%22%3EI'm%20not%20sure%20I%20understand%20exactly%20but%20as%20I%20think%20you%20mentioned%2C%20sorting%20in%20a%20column%20is%20very%20easy%20so%20you%20could%20copy%20and%20Paste%20SPECIAL%20-%26gt%3B%20Transpose%20to%20convert%20the%20data%20from%20rows%20to%20columns.%20Then%20you%20can%20sort%20and%20if%20need%20do%20it%20again%20to%20go%20back%20to%20rows.%20Not%20elegant%20but%20works%20and%20you%20might%20consider%20if%2Fwhy%20you%20have%20the%20data%20organized%20in%20rows%20and%20if%20you%20could%20change%20your%20sheet%20to%20be%20organized%20in%20columns%20instead.%3C%2FLINGO-BODY%3E
Occasional Visitor
Tengo una base de datos con más de 1000 filas e con 15 columnas. Todos los datos son números enteros entre 1 e 100, más preciso organizar todos ellos, en sus correspondientes filas, de menor a mayor. Cómo lo puedo hacer?? Por columnas, sé que es bien sencillo, más como hacerlo por filas?

Gracias.
1 Reply
I'm not sure I understand exactly but as I think you mentioned, sorting in a column is very easy so you could copy and Paste SPECIAL -> Transpose to convert the data from rows to columns. Then you can sort and if need do it again to go back to rows. Not elegant but works and you might consider if/why you have the data organized in rows and if you could change your sheet to be organized in columns instead.