http://reshapexl.com Software for data wrangling en-us Sunday, April 5, 2026 milos.gregor@reshapexl.com Read this post if you get at the installation this error message: "System.Security.SecurityException: Customized functionality in this application will not work because the certificate used to sign the deployment manifest for ReshapeXL or its location is not trusted. Contact your administrator for further assistance." http:/reshapexl.com/Post.aspx?Id=60&Title=System.Security.SecurityException%3a+Cannot+instal+the+software Tuesday, August 23, 2022 Some time ago I published an online app for COVID-19 data analysis and visualization. http:/reshapexl.com/Post.aspx?Id=59&Title=Online+COVID-19+dashboard Sunday, June 7, 2020 Another function you can use in the data processing in the Reshape.XL add-in is the Distinct function. This function allows you to select unique rows in your Excel spreadsheets. Therefore, the function removes duplicate table rows. http:/reshapexl.com/Post.aspx?Id=58&Title=How+to+Select+Distinct+%2f+Unique+Rows+from+Excel+Tables Sunday, September 29, 2019 This post is another very powerful feature of the Reshape.XL add-in - Complete. This function is useful if you want to add missing values to your Excel tables. These can be categorical values as well as continuous values, such as time series or sequences of numerical values. The Complete function also allows you to add missing combinations of multiple variables in your datasets. http:/reshapexl.com/Post.aspx?Id=57&Title=How+to+Complete+Missing+Cases+in+Excel+Table Wednesday, September 11, 2019 Missing data is very common in our datasets. Their origin may be diverse - measurement drop, data write errors or records removing during the data cleansing process. For some statistical analyzes we need tables without missing data. We need to either remove these incomplete rows, fill in the empty cells, replace them by constant value or select rows with missing data. http:/reshapexl.com/Post.aspx?Id=56&Title=4+Interesting+Functions+for+Missing+Values+Processing+in+Excel Wednesday, August 21, 2019 In Excel, we often separate values from one column into several new ones. Several built-in features or plug-ins can be used for this purpose. The problem arises when you want to separate values from one column (cell) into several consecutive rows - separate_to_rows. This post shows how you can use Reshape.XL add-in. http:/reshapexl.com/Post.aspx?Id=55&Title=How+to+Separate+Column+To+Rows Monday, August 12, 2019 One of the most common features we use in Excel is to separate values from one column to multiple. Likewise, this function is often used in other environments (such as programming languages) to prepare input data for further analysis. This article shows you the capabilities that the Reshape.XL interface provides for these purposes. http:/reshapexl.com/Post.aspx?Id=54&Title=13+Ways+How+to+Separate+Excel+Columns Sunday, July 28, 2019 Combining Excel cells is a fairly frequently used feature. This article introduces the Unite function from the Reshape.XL add-in. This feature makes it easy to quickly combine selected spreadsheet cells. http:/reshapexl.com/Post.aspx?Id=53&Title=How+to+Combine+Several+Excel+Columns+into+One Monday, June 24, 2019 Table columns renaming is easy if you do it directly in a spreadsheet. Different it is inside the Reshape.XL add-in. In a spreadsheet, you click the selected cell and overwrite it. http:/reshapexl.com/Post.aspx?Id=52&Title=How+to+Rename+Table+Columns Wednesday, May 22, 2019 In this post, I want to inform you about the Reshape.XL add-in subversions and their relationship to the licenses you purchased. http:/reshapexl.com/Post.aspx?Id=51&Title=FAQ%3a+Add-in+Subversions+and+Your+License Sunday, May 12, 2019 In the download section you can download the new version of the Reshape.XL add-in. http:/reshapexl.com/Post.aspx?Id=50&Title=Reshape.XL+1.2+is+Available Sunday, April 28, 2019 Quite often I get the question of the difference between the Reshape.XL and Power Query add-ins. Both serve the same purpose - more efficient processing of tabular data from your Excel spreadsheets. With both, you can achieve the same results for 95 %. The difference is in their internal architecture, way of working and ease of use. http:/reshapexl.com/Post.aspx?Id=49&Title=FAQ%3a+Is+Reshape.XL+an+alternative+to+Power+Query%3f Monday, April 15, 2019 Sometimes it happens that we work with large datasets - datasets that contain tens to hundreds of columns. However, for some analysis or processing steps, we often do not need to see all the columns. We also want to display them in a different order - for example, categorical variables (dimensions) at the beginning and numerical at the end. http:/reshapexl.com/Post.aspx?Id=48&Title=How+to+Select+and+Reorder+Excel+Data+Columns Monday, April 8, 2019 One of the most important spreadsheet functions is to sort table values by selected columns. This post shows you how to sort Excel data within the Reshape.XL add-in using two interesting functions. http:/reshapexl.com/Post.aspx?Id=46&Title=2+Interesting+Functions+For+Excel+Table+Sorting Monday, April 1, 2019 Variable formatting is an important part of the data preparation prior to statistical processing. Automatic conversion and data type recognition in Excel sometimes causes great problems. These problems often resulting in errors at statistical processing. Within the Reshape.XL add-in, the approach to the definition of data types is different. http:/reshapexl.com/Post.aspx?Id=45&Title=Format+Variables+in+Reshape.XL Wednesday, March 20, 2019 Data pivoting and unpivoting is an important part of data analyst work. In the case of described two steps, it is about tables transformation between “long” and “wide” form. Simply speaking, we want to make rows from multiple columns or (vice versa) to create several new columns from the Key-Value pair of columns. http:/reshapexl.com/Post.aspx?Id=44&Title=How+to+Pivot+and+Unpivot+Excel+Data Thursday, March 14, 2019 From now on, you can download and install an updated version of Reshape.XL add-in. This release contains several enhancements that improve and accelerate the use of the add-in. http:/reshapexl.com/Post.aspx?Id=43&Title=Reshape.XL+1.1+is+Available Friday, March 1, 2019 If is often the case that we have a larger dataset in Excel that needs to be processed statistically. It is also necessary to carry out this summation (average or sum) on groups that are defined by a categorical variable. http:/reshapexl.com/Post.aspx?Id=42&Title=Process+and+Summarize+Excel+Data+in+Groups Wednesday, February 20, 2019 The Reshape.XL add-in has one interesting function  -  Pack. This function is used to remove blank rows or columns. http:/reshapexl.com/Post.aspx?Id=41&Title=Remove+Empty+Rows+and+Columns+from+Excel+Spreadsheet Wednesday, February 13, 2019 You can transpose the Excel table in three ways - using the Special Insert, the TRANSPOSE function and using the Pivot Tables. However, all these methods have some problem and their use is not straightforward and fast. In the Reshape.XL add-in it is possible to transpose tables very quickly using the Transpose function. In addition to simplicity, this feature brings also some customizability options. http:/reshapexl.com/Post.aspx?Id=40&Title=How+to+Transpose+Excel+Table Thursday, February 7, 2019