How to append multiple columns from different sheet into one signal data in alteryx

[Ekmi9]

hello Everyone,

Need urgent help on below mention use case :

How to append multiple columns from different sheet into one signal data in Alteryx.

number of sheets dynamic and columns as well.

Thanks in advance !

sample input and output

Output:

A

B

C

D

E

AA_Sheet1_F

AA_Shhet1_G

AA_Sheet1_H

BB_Sheet1_I

BB_Sheet1_J

BB_Sheet1_K

BB_Sheet1_L

BB_Sheet1_M

BB_Sheet1_O

CC_Sheet1_N

CC_Sheet1_P

CC_Sheet1_Q

CC_Sheet1_R

CC_Sheet1_S

AA_Sheet2_X

AA_sheet2_Y

AA_sheet2_Z

BB_sheet2_O

BB_Sheet2_P

BB_Sheet2_Q

BB_Sheet2_R

CC_Sheet2_BB

CC_Sheet2_BE

CC_Sheet2_ED

Input :  

Sheet 1

AA

BB

CC

A

B

C

D

E

A

B

C

D

E

A

B

C

D

E

A

B

C

D

Sheet 2,

AA

BB

CC

A

B

C

D

E

X

Y

Z

O

P

Q

R

BB

BE

ED

[binuacs]

@Ekmi9 Can you upload some sample data with the proper heading and expected output? The given sample data is confusing.

[Raj]

Please share some more details about the requirements also as @binuacs  said correctly it will be better if you can provide some sample data as well

[Ekmi9]

Sorry I can not share any sample data but in every sheet i have different sub column and on top of that i have different main headers (like AA is main Header and FGH sub Header under that) 

AA

BB

CC

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

[CoG]

Here is a sample workflow based on some assumptions about how your data would need to be laid out to make sense:

Main Workflow:

Batch Macro: