Hello excel master in here. Anyone help me? I want any help but it's difficult to be explained. So I attach the picture for explaining. Here it is the 2014-12-09_021258.png .
I want Collect datas vertical column B from the same string column A or collect datas vertical column B from the same string column A and be one column with separated by pipe. In this picture, I want the data result that has red font in this picture. Any Formula or function? I attach the example.xlsx example1.xlsx.
Many thanks
Bookmarks