Concatenating and removing Headers with (F1-infinity)

[Rinearb]

How can I remove all similar Header Names to F1, make them blank, then concatenate all rows to 1 column?

Please Help Me	Who
F1	What
F2	Where
F3	When
F4	Why
Please Help Me	How

Ideal Outcome:

Please Help Me Who

What

Where

When

Why

Please Help Me How

[atcodedog05 · Accepted solution]

Hi @Rinearb 

Here is how you can do it.

Workflow:

Hope this helps : )

[Rinearb]

Thank you for the quick response. This is exactly what I needed

[atcodedog05]

Happy to help : ) @Rinearb 

Cheers and have a nice day!