Forum Discussion
Solved
Problems when importing CSV file
I have a CSV file that I've imported and set "comma" as the delimiter. However, the way the CSV was formatted, I'm running into issues. Below, table 1, is what Power BI & Excel automatically transfor...
brandanb , In data transformation/edit query you have an option to split column. Split column into rows. use that
check steps
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
brandanb , In data transformation/edit query you have an option to split column. Split column into rows. use that
check steps
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/