The picture above shows data presented in only one column (column B), this happens sometimes when you get an undesired […]

Comments(0) Filed in categories: Excel, INDEX function, Rearrange values

The user defined function demonstrated below, resizes a range you specify to columns or rows you also specify. The first […]

Comments(1) Filed in categories: Excel, Rearrange values

Here is another macro to normalize data. Scenario: The user has entered multiple values in the same cell. The macro […]

Comments(0) Filed in categories: Excel, Normalize data, Rearrange values

Debra has a great post and video about normalizing data for excel pivot table. This post describes a macro that normalizes […]

Comments(12) Filed in categories: Excel, Normalize data, Pivot table, Rearrange values