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 below, resizes a range you specify to columns or rows you also specify. The first […]

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 […]

Text to be on top of column

Question: I have a text name coloumn, there will be only 1 value to be listed in 1 coloumn in […]