convert multiple rows to single row in excel ( countif | vlookup | textjoin )

preview_player
Показать описание
combine multiple rows into one row excel
in this video I will show you how to convert multiple rows to single row in excel using countif, vlookup and textjoin formulas.
Рекомендации по теме
Комментарии
Автор

I was searching formulas for this type of scenario, It will be really helpfull for me.

dinesh
Автор

Can this be used if "category' values are numbers? Not working for me, please suggest

Aashirwad-zpfq
Автор

NOW, IT'S ONLY 2 FIELDS (CATEGORY AND COURSE), HOW ABOUT I HAVE MORE (CATEGORY, COURSE, DURATION) ???

thongvuongminh
join shbcf.ru