Merging multiple columns together

[Saravanan13]

Hello,

I am working on PDF extract data in which "City or town, state or province2 & City or town, state or province" is not getting properly aligned. Currently the input data contains extract of two PDFs. The issue is "City or town, state or province2" is getting split into multiple columns randomly.Sometimes it is getting aligned properly but sometimes it is getting split in to more than on column.

I would need this column to reflect as shown in output. Basically if the column name contains "City or town, state or province" then I need all the values for the column in one column. Is there way to handle this dynamiically.

Input -

Row	Form	Permanent address	Affirmation	Revision	Citizenship	8 Date of birth	Name	City or town, state or province2	City or town, state or province
12345	W-8BEN	118 ABC	No	10-2021	India	1/1/1901	John	INDIA 111111
678910	W-8BEN	255 CDE	No	10-2021	Srilanka	1/1/1901	Mark		222222

Output - 

Row	Form	Permanent address	Affirmation	Revision	Citizenship	8 Date of birth	Name	City or town, state or province
12345	W-8BEN	118 ABC	No	10-2021	India	1/1/1901	John	INDIA 111111
678910	W-8BEN	255 CDE	No	10-2021	Srilanka	1/1/1901	Mark	222222

[flying008]

Hi, @Saravanan13 

Here you are:

******

If can help you get your want, please mark it as a solution and give a like for more share.