Hi all,
I have been going through all of the possible answers in Mr Excel and none of them seems to fit my specific problem.
I would just like to have a scenario like this:
1
2
3
4
5
This must be copied horizontally n times.
Thus lets say A1 = 5, then the output must be:
1 1 1 1 1
2 2 2 2 2
3 3 3 3 3
4 4 4 4 4
5 5 5 5 5
I have been going through all of the possible answers in Mr Excel and none of them seems to fit my specific problem.
I would just like to have a scenario like this:
1
2
3
4
5
This must be copied horizontally n times.
Thus lets say A1 = 5, then the output must be:
1 1 1 1 1
2 2 2 2 2
3 3 3 3 3
4 4 4 4 4
5 5 5 5 5