How can I remove all similar Header Names to F1, make them blank, then concatenate all rows to 1 column? Please Help Me WhoF1 WhatF2WhereF3WhenF4WhyPlease Help MeHow Ideal Outcome: Please Help Me Who WhatWhereWhenWhyPlease Help Me How

Concatenating and removing Headers with (F1-infinity)

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

Ideal Outcome:

Please Help Me Who

What

Where

When

Why

Please Help Me How

Workflow

Datasets

Developer

Fuzzy Match

Here is how you can do it.

Workflow:

Hope this helps : )

Here is how you can do it.

Workflow:

Hope this helps : )

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