Column Dynamic Combine

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

Macros

Dynamic Processing

Accepted answers

LordNeilLord

@Rohitpm

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

xml.yxmd

All comments

LordNeilLord

Hi @Rohitpm,

Can you provide an example? I can't picture in my head what you need to happend

Rohitpm

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703