Create a list based on input cells.

[Closed]
Report
Posts
16
Registration date
Tuesday June 1, 2010
Status
Member
Last seen
July 11, 2012
-
Posts
16
Registration date
Tuesday June 1, 2010
Status
Member
Last seen
July 11, 2012
-
Hello,

I am trying to create a vertical list based on cell in sheet2 with various data in sheet1

example file is saved in :
http://www.editgrid.com/user/j3kj3k/Book1

Thanks in advance.

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You would need a macro for that

Can each row have partial repeation

like R1, apple 1000 is on row 1, can it also appear on some other along with some other data. If that is the case then what to do ?
Posts
16
Registration date
Tuesday June 1, 2010
Status
Member
Last seen
July 11, 2012

Yes it can.
I will be able to screen them out if it is necessary.

Thanks for looking into my issue :)
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
How many rows are we talking about here .

One approach can be
loop thru each row
loop thru each column
split the content by comma
write to list
next column
next row

but depends on rows columns and how many items can be in one cell ?
Posts
16
Registration date
Tuesday June 1, 2010
Status
Member
Last seen
July 11, 2012

Hi rizvisa1
rows (100-200) and columns (30-50) are varying.
and one item per one cell please.
Hope I made it clear.
Thanks in advance.

If it is too much trouble for multiple rows, I can run your script one row at a time.