Forum Discussion
Solved
Data Layout Advice
Hi, I am pulling a lot of data into Power BI from Online Excel sheets, and am finding it hard to lay the data our in a way that Power BI can use it. hopefully this is just be being new...I am hop...
Hi,
In the Power Query Editor, right clock on the first 2 columns and select "Unpivot Other Columns". Split the attribute column into 2 using space as a delimiter. The data should not become usable.
Hi,
In the Power Query Editor, right clock on the first 2 columns and select "Unpivot Other Columns". Split the attribute column into 2 using space as a delimiter. The data should not become usable.