ExcelBanter - autogenerate multiple rows from single entries in different sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - autogenerate multiple rows from single entries in different sheet (https://www.excelbanter.com/excel-programming/352555-autogenerate-multiple-rows-single-entries-different-sheet.html)

stratis

autogenerate multiple rows from single entries in different sheet

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

Jim Thomlinson[_5_]

autogenerate multiple rows from single entries in different sheet

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

All times are GMT +1. The time now is 08:06 AM.