Forum Discussion
Unable to deselect in excel
How can I go from deselecting perfectly yesterday to double selecting today!?
43 Replies
- rayeverestCopper Contributor
You might try Pivot Tables in Excel.
rayeverest, Pivot Tables will be of no help in this situation unfortunately. They work well with structured columns of data.
- coughlanconsultingCopper Contributor
Hi Wyn
Many thanks for the information. I can see how this would be a great resolution to my problem, assuming there was good and logical source data. Unfortunately when I look further into the detail of the report not all of the rows under each client/ prospect name start with the same identifier, some clients have different rows of details with multiple addresses, or multiple key staff or email addresses etc i.e. the simple version I provided to you doesn't reflect the complexity of the actual source data. As a result the transformed report then gets out of order. Appreciate the assistance but maybe all the errors and issues in the set up are going to defeat our best efforts
- Hi,
Ah, yes unless there is some sort of pattern / logic / consistent identifier automating a solution becomes next to impossible and good old manual re-keying becomes the best approach.
I've attached a an Excel File containing a Power Query routine that should help solve your issue
You will need to go into Data > Queries and Connections and then double click on Clean Data in the right hand pane to open up Power Query
Click on the cog next to Source and pick your file name that contains the messy data
Also I've assumed the data is on Sheet1, if not click the cog next to Navigation
Then click on the last step "Removed Columns 1" and you should see your data cleaned up. Then click Close and Load
- Hi
Could you post a sample of the file so I can see how it's structured. Sounds like something that Power Query can resolve.