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