I attempted to attach a spreadsheet, but it wouldn't work.
The best I can do is provide the screen shot below.
Example image.jpg
This is a difficult problem to explain using only words, but I will do my best.
I have Column Q which shows a material, and then Columns R-AB showing the sizes that the material is available in.
There are some blank values in Columns R-AB because not all materials are available in all sizes.
That leaves me with a data set that looks something like this:
T1001 21 22
T1002 22 24 25
T1003 30
I want to convert this data so that everything is listed in two columns vertically in AD and AE, like below:
T1001 21
T1001 22
T1002 22
T1002 24
T1002 25
T1003 30
I'm trying to use INDEX, but I'm hitting a wall. Any ideas?
Bookmarks