Group Multiple Tables from the Same Spreadsheet

[alexlyle]

Currently, I have 3 sets of columns next to each other in the same spreadsheet I need Alteryx to merge them into a single set. Please see the attached document for examples.

[OTrieger]

@alexlyle 

Have you tried to transpose the data?

[binu_acs]

@alexlyle one way of doing this with a batch macro with dynamic select tool, make sure that your columns names are having an identifier to differentiate each tables