Hi, I have some problem. In one sheet I have some data like this:
A B C
1 Nicolla street1 5
2 Mikel street2 3
3 Andrea street3 4

I want that data in another sheet to look like this:
A B
1 Nicolla street1
2 Nicolla street1
3 Nicolla street1
4 Nicolla street1
5 Nicolla street1
6 Mikel street2
7 Mikel street2
8 Mikel street2
9 Andrea street3
10 Andrea street3
11 Andrea street3
12 Andrea street3
13 Andrea street3

How can you see, number in column C mean number of rows and copy.
How can I resolve that problem? Preferably directly when you type a number in the cell to automatically copy to another sheet.