Forum Discussion
HELP TO GRAPH multiple data
Step by step...
Select the column and, under the Home tab, click on Split column -> by delimiter
Type in the delimeter in the box, and in advanced options chooe split into rows.
Finally select the column and under the Transform tab, select Format and Trim and then Clean.
Hi,
In the Query Editor, split the second column by rows with / as a delimiter. Now create your desired visual.
THANKS FOR YOUR TIME.
I have to do the analisys of that data and i have a problem...
One of those cells have multiple data in one cell for example
ID DATA
X A / B / C / D
Y C / D
I need know how many have each ID in ESPECIFIC data and get that in a table:
A B C D TOTAL
X 1 1 1 1 4
Y 1 1 2
6
I tried to do that with split column but the table just give me the first data found in the first column
A B C D TOTAL
X 1 1
Y 1 1
2
I managed to do the exercise by making a table by column, but I need the data in a single table like this:
A B C D TOTAL
X 1 1 1 1 4
Y 1 1 2
6