How to fill values between two specific cells?

[media-tel]

I have a sheet i'm working on as follows for an automotive inventory

Column A Column B
1953 1959
1953 1956
1962 1969

I need to combine the 2 columns and fill in the years between so I'd end up with a column as follows
Column A
1953,1954,1955,1956,1957,1958,1959
1953,1954,1955,1956
1962,1963,1964,1965,1966,1967,1968,1969

Is there a way to do this?

[mehmetcik]

run this macro

Please Login or Register  to view this content.

[pjwhitfield]

Please Login or Register  to view this content.

EDIT: had the output going into individual columns rather than all in A

[media-tel]

Gives me an error. Which cells should I highlight?

[pjwhitfield]

Which code had error and what was it?

[Tony Valko]

Here's another one.

Copy the code at the link below and paste it into a general module.

https://www.excelforum.com/showthread.php?p=3096647

Then, to use it...

Data Range

	A	B	C	D
1	Start	End	------	Concatenated
2	1953	1959		1953, 1954, 1955, 1956, 1957, 1958, 1959
3	1953	1956		1953, 1954, 1955, 1956
4	1962	1969		1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969
5

This array formula** entered in D2 and copied down:

=concatall(ROW(INDIRECT(A2&":"&B2)),", ")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.