With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, May 26, 2012
yogi_Expand An Item Count Into Corresponding Number Of Rows
user fearless said: expand an item count into a number of rows [Using Chrome/OS X, but that's probably not relevant.]
Consider the following on one sheet:
quantity, description, accumulated
0, pony, 0
4, lollipop, 4
2, rainbow, 6
1, fairy, 7
On another sheet, I'd like that to expand to be:
that is: I get <quantity> rows of each item. I can do this with a nested IF statement, but there's a nested IF for each item, so it gets unwieldy very quickly. I'd prefer NOT to resort to scripting. VLOOKUP holds promise, but I haven't been able to make it jump through this particular hoop.