مطالب مرتبط با «horizontally in excel» در Recent Questions | نویسنده: استخدام کار
Print values horizontally in Excel
I have an Excel sheet with data formatted as below A B 1 KEY VALUE 2 Apple Golden 3 Orange Navel 4 Banana Yellow 5 Apple Gray Smith 6 Orange Blood What I want to do is take the unique keys, but print their corresponding values horizontally next to them. I already have a sheet that looks like this: A B 1 KEY VALUE 2 Apple Golden 3 Orange Navel 4 Banana Yellow But what I would like is this: A B C 1 KEY VALUE1 VALUE2 2 Apple Golden Gray Smith 3 Orange Navel Blood 4 Banana Yellow My formula right now is {=INDEX('$B$2:$B$6,MATCH(,$A$2:$A$6,0))} where "unique key" is the cell reference in the second sheet. This formula successfully prints the first value for each key, but I would like for the othe...
ادامه مطلب
