Forum Discussion
Split Column with multiple values in same column
The difference is that in one Column the file can have more than one Company, like these:
Anonymous
You will have to duplicate the query and then use Remove Rows and Use First Row as Headers to transform the table into multiple queries containing one table of data each:
Then add a column to each query so that the columns match across queries. Use add custom column with a value of = null
Once the columsn in all your queries match up, append the queries as new to put them all together:
Now right click on the date and select unpivot other columns:
Thanks.
That will work for one file.. But is there any way I can automate this? The file is updated daily and it's a lot of work to update it daily. I'll need to check columns and positions every day.. There must be an easier way.. I hope!
Thanks