How to pick the data from dynamic columns

[amsrivastava]

Hi Folks!!

I am getting input files where structure of the input file is not in sync as shown below

Format - 1

		Organization
	Data2	Corporate
Data 1		Weeks	1	2	3
		Hours	3	4	7

Format - 2

				Corporate
ABC				Weeks	1	2	3	4
				Hours	2	2	3	2

Format - 3

ANC	Data				Weeks	1	2	3
					Hours	4	2	2

I need to pick data above highlighted in RED, i.e only for the Rows and Columns where we have WEEKS and HOURS as a text no matter where it is available.

Please suggest how to achieve this in Alteryx.

Note - I don't have column Header in any of the format

Thanks

A 

[aatalai]

@amsrivastava does the attached workflow help?

[binuacs · Accepted solution]

@amsrivastava