Forum Discussion
Split Column with multiple values in same column
Hi I have a file with multiple columns, where each column can be one or more companies. Something like the following format: Date | Company1 | Company2 01-02-2019 | 1000 ...
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