00:00This is one Excel tip you definitely want to know. Say, for example, if you have column B with just
00:05purely names and the second column in your data set is a series of data but it's comma separated,
00:10how you convert this data set table into this table so that you can do sum and total and all
00:15that stuff. So this is how you do it. The first thing you're going to have to do is basically
00:19combine these two cells into one string using a function called text join and then the first
00:27argument will be the delimiter. We're going to be using the comma as a delimiter and the second
00:32argument we're going to ignore the empty cells placed through and the third argument would be
00:39the row of data like this. Close parenthesis and hit enter and what you'll see is you'll see that
00:44that the formula basically combined this and this into one string itself. Now we're going to split
00:51it based on the delimiter of comma. So you're going to encapsulate text join with text split like this
00:57open parenthesis. The first argument will be the text join function itself. Second argument is your delimiter
01:04which is your comma like that and close parenthesis and hit enter. What that does is I
01:09create an array of numbers or other array of elements which is assigned to each individual
01:15cell like this. Now all you have to do is to apply the same formula to the rest of the row by dragging
01:20the formula right all the way down like this and you're done.
