Hi Guys
I am reading table data from an XML which is from pdfs. These column names can be slightly different or exactly the same name.
The batch macro i have created kicks out the columns of the tables.
As such i am looking at a way to dynamically combine different columns together. The columns will only have the data or null values in
Cheers
Solved! Go to Solution.
So here is an example of what i mean
Cost1 | Cost2 | Total1 | Total2 | Per1 | Per2 | Per3 | Per4 |
1 | |||||||
2 | |||||||
3 | |||||||
4 | 9 | ||||||
5 | |||||||
6 | |||||||
7 |
So i am trying to combine the fields that have a similar name so it is like this:
Cost | Total | Per |
1 | ||
2 | ||
3 | ||
4 | 9 | |
5 | ||
6 | ||
7 |
Hope that makes sense
I think you first need to transpose your data so it's long rather than wide, then look at how to identify the same names (in your example it was easy because you just need to remove the number but I suspect your actual data will be much harder). After that you can crosstab the data back into it's original format.
I'm not expecting your final workflow to be a simple as this but this should get you started.
If you want to post some examples of the actual headers that you are getting I can help you further
Cool thanks alot :)