Forum Discussion
Formatting Issue (Getting data from 1 column into 7 columns)
Hello. I'm having a devil of a problem trying to import data from the web and getting it into Excel in roughly the same columned format. I'm copying the relevant data (which is information that I've...
Subodh (and Sergei)...thank you very much for responding. I've tried both of your Power Querys and get the same message:
Expression.Error: We couldn't find an Excel table named 'WebData".
Details:
WebData
What am I doing wrong?
- Jeff
And much better, if you don't copy/paste from web but query the web, combine transformations suggested here with the initial query. If that's copy/paste perhaps it's worth to try query the web, finally it'll be one click solution - open the file, refresh all.