N
Nikul Padhya
I have a worksheet, which has random but Sorted data already.
The column A has all the Id no. and rest of the columns have ether a
blank or a String data.
The Id in Column A can be duplicate in the preceding Row too.
Example
Col1 Col2 Col3
10 A
10 B
11 A
11 C B
11 D
I want to merge the rows only if all the entire data can be copied.
(in case if Id 10)
but incase of Id 11 I want to merge the data such as it does not over
write.
Expected answer
Col1 Col2 Col3
10 A B
11 A B
11 C D
I have some partial knowledge
but I am confused, that should i use multiple for loop to gothrough
the columns again? or the is a function in excel.
Thanks everyone for trying in advance
The column A has all the Id no. and rest of the columns have ether a
blank or a String data.
The Id in Column A can be duplicate in the preceding Row too.
Example
Col1 Col2 Col3
10 A
10 B
11 A
11 C B
11 D
I want to merge the rows only if all the entire data can be copied.
(in case if Id 10)
but incase of Id 11 I want to merge the data such as it does not over
write.
Expected answer
Col1 Col2 Col3
10 A B
11 A B
11 C D
I have some partial knowledge
but I am confused, that should i use multiple for loop to gothrough
the columns again? or the is a function in excel.
Thanks everyone for trying in advance