I have two sheets with this data:
For sheet 1, a piece of the data is like this:
Entry Hybrid Company
1 Belle 1533Y Belle Southern Hybrids
2 Belle 1525R Belle Southern Hybrids
3 Belle 1545RY Belle Southern Hybrids
4 Belle 1747 RY Belle Southern Hybrids
for the sheet 2, I have just have the entry number replicated four times:
Entry number
1
1
1
1
2
2
2
2
3
3
3
3
4
4
4
4
I need to match entry number in sheet 1 and 2, then insert column 2 and 3 in sheet two.
The way that the data have to be arranged is this:
1 Belle 1533Y Belle Southern Hybrids
1 Belle 1533Y Belle Southern Hybrids
1 Belle 1533Y Belle Southern Hybrids
1 Belle 1533Y Belle Southern Hybrids
2 Belle 1525R Belle Southern Hybrids
2 Belle 1525R Belle Southern Hybrids
2 Belle 1525R Belle Southern Hybrids
2 Belle 1525R Belle Southern Hybrids
3 Belle 1545RY Belle Southern Hybrids
3 Belle 1545RY Belle Southern Hybrids
3 Belle 1545RY Belle Southern Hybrids
3 Belle 1545RY Belle Southern Hybrids
4 Belle 1747 RY Belle Southern Hybrids
4 Belle 1747 RY Belle Southern Hybrids
4 Belle 1747 RY Belle Southern Hybrids
4 Belle 1747 RY Belle Southern Hybrids
and so on....
I know that I can do this by copy and paste, but I have a large amount of data so I need to do it in a better way, please, I need some help. When I work in a previous company, they used a macro to match data columns, then insert the next 2,3 or 4 colums. I know that there is a way to do it, but I do not know how
Does somebody know?
thanks for your help
Bookmarks