Hi All,
In the attached Excel file, in sheet 1, you will see the values as below:
A B
1 a
b
c
2 x
y
z
3 l
m
n
and i want to change the values as attached in sheet 2 as below:
A B
1 a
1 b
1 c
2 x
2 y
2 z
3 l
3 m
3 n
Kindly help to provide the steps.
Thanks in advance,
Adil Khan
Bookmarks