Yes colum is in 3 columns(could vary actually) but the number is always at
the end- right

"Jim Thomlinson" wrote:

> Is the source data in 1, 2 or 3 columns? For example is column A Sales,
> column B State1 and column C 3, or???
> --
> HTH...
>
> Jim Thomlinson
>
>
> "stratis" wrote:
>
> > I want to generate a multi row spreadsheet from a single entries
> > ie
> > Sales1 state1 3
> > Sales2 state2 2
> > Sales3 state3 0
> > to become
> > Sales1 state1
> > Sales1 state1
> > Sales1 state1
> > Sales2 state2
> > Sales2 state2