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 |
Solved! Go to Solution.
Thank you for the quick response. This is exactly what I needed
Happy to help : ) @Rinearb
Cheers and have a nice day!