Rearrange values

Excel » Rearrange values »

Rearrange values

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

Resize a range of values

The user defined function demonstrated in the animated ggif below, resizes a range you specify to columns or rows you also […]

Normalize data, part 2

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

Normalize data [VBA]

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