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
WebData is the table with raw data which you shall create. Select all raw data in column A, press Ctrl+T and create the table.
On ribbon you will stay on Table Design
Type here table name now