Forum Discussion
Text as the chart source.
I would like the text from the column "date"="41;205;61;182;81;200;101;207;121;211;141;209;161;204;181;198;201;187;221;181;241 ;176;261;169;281;163;301;161;321;156;341;155;361;153;381;153;401;152" to...
Thank you for your answer.
But how to divide the data so that in column X there are only odd value IDs and in column Y even.
- Create a new query by clicking on "Edit Queries" in the Home tab.
- Select the table containing the "date" column.
- Click on the "Transform Data" button.
- Click on the "Split Column" dropdown and select "By Delimiter."
- In the Split Column dialog box, select "Custom" as the delimiter type.
- Enter a semicolon ";" as the custom delimiter.
- Select "Even Columns Only" and click "OK."
- Rename the new column to "Y" by right-clicking on the column header and selecting "Rename."
- Repeat steps 4-8, but this time select "Odd Columns Only" and rename the new column to "X."
- Close and Apply the changes.