Forum Discussion
Getting a new table from existing spreadsheet with multiple tables
So I have an excel sheet having tables consisting of data from multiple years. I want to generate a new table with data from the respective year. I want also to have it such that, I don't have to man...
Ashish_Mathur
Super User
Super UserHi,
That data is in a very poor format. You should ideally have a 4 column table (the fourth column being the year column). That table should then be imported in PowerBI Desktop.