Hi,
am using excel 2007 version
i just want a simple task getting confused how to do please help me thanks in advance
my task is in one sheet have rows 1,2,3,4,5 in another sheet has a,b,c,d rows
12345 rows add to abcd equally i mean 1 has abcd, 2 has abcd, 3 has abcd
it means 5*4= total 20 rows
am using excel 2007 version
i just want a simple task getting confused how to do please help me thanks in advance
my task is in one sheet have rows 1,2,3,4,5 in another sheet has a,b,c,d rows
12345 rows add to abcd equally i mean 1 has abcd, 2 has abcd, 3 has abcd
it means 5*4= total 20 rows
Sheet 1 | 1 | ||
2 | |||
3 | |||
4 | |||
Sheet 1 | a | ||
b | |||
c | |||
d | |||
Result | |||
1 | a | ||
1 | b | ||
1 | c | ||
1 | d | ||
2 | a | ||
2 | b | ||
2 | c | ||
2 | d | ||
3 | a | ||
3 | b | ||
3 | c | ||
3 | d | ||
4 | a | ||
4 | b | ||
4 | c | ||
4 | d | ||
5 | a | ||
5 | b | ||
5 | c | ||
5 | d | ||