First post, and yes, I did search but wasn't sure what to search by (I did try various searches but to no avail). Suppose in Sheet1 I have these 2 cells: 33206 to 33208 33210 to 33214 Now what I need to do is to create a list on Sheet2 that...
First post, and yes, I did search but wasn't sure what to search by (I did try various searches but to no avail).
Suppose in Sheet1 I have these 2 cells:
33206 to 33208
33210 to 33214
Now what I need to do is to create a list on Sheet2 that takes Sheet1's cells as an input and outputs on column A:
33206
33207
33208
33210
33211
33212
33213
33214
Any ideas? I can do this manually by taking "33206 to 33208" and spreading it out horizontally then manually copy/pasting the cells transposed, but this is not feasible when I have like a hundred of these.
TIA!