00:00Want to see the most cringiest task ever assigned to me in Excel?
00:03The task here is to split each brand into its own row and extract the common unit's soul,
00:07making the table look something like this.
00:10Well, it is not as hard as it looks. Let's learn.
00:13Let's start off by getting our brand column.
00:15We'll use the text join function to concatenate the brand into one continuous string like this.
00:20And after that, we'll split the string using a text split function with comma being the delimiter.
00:25And since the brand needs to be in vertical orientation, we'll use the transpose function that completes our brand column.
00:32And now for the unit's soul column, we'll be using the XLOOKUP function.
00:35We'll use the lookup value to be a wildcard for the brand in cell E3.
00:40And the lookup array would, of course, be the brand.
00:43And then the return array would be the unit's soul column.
00:46And since we're using a wildcard, we'll assign two for match mode.
00:50And after that, you apply the same formula across every rows.
00:53And then job done!
00:55And then job done!
00:55And job done!
00:55And job done!
00:55And job done!
Comments