Problem to convert a TXT file to Excel file with Macros

[OmarGtz]

Hi All,

I need to create a macro that allows me to convert a TXT file with multiple level headers that are repeated across each registry and sort them in a single column, I have not constructed any macro cause simply I'm lost on this, I appreciate your support!

Here the example

Registry 1
Header Lvl1 A space, space Header Lvl1 B space Header Lvl1 C
Data Lvl1 A space, space Data Lvl 1 B space Data Lvl 1 C
Header Lvl2 A space, space Header Lvl2 B space Header Lvl2 C
Data Lvl2 A space, space Data Lvl 2 B space Data Lvl 2 C
Header Lvl3 A space, space Header Lvl3 B space Header Lvl3 C
Data Lvl3 A space, space Data Lvl 3 B space Data Lvl 3 C
Registry 2
Header Lvl1 A space, space Header Lvl1 B space Header Lvl1 C
Data Lvl1 A space, space Data Lvl 1 B space Data Lvl 1 C
Header Lvl2 A space, space Header Lvl2 B space Header Lvl2 C
Data Lvl2 A space, space Data Lvl 2 B space Data Lvl 2 C
Header Lvl3 A space, space Header Lvl3 B space Header Lvl3 C
Data Lvl3 A space, space Data Lvl 3 B space Data Lvl 3 C

Please note that headers of each Level are the same within registries (Registry field doesn't exist) and Lvl1 is the one that actually differentiates each registry.

The expected result is:

Header Lvl1 A space, space Header Lvl1 B space Header Lvl1 C, Header Lvl2 A space, space Header Lvl2 B space Header Lvl2 C,Header Lvl3 A space, space Header Lvl3 B space Header Lvl3 C
Each data registry

---

listed below
Data Lvl1 A space, space Data Lvl 1 B space Data Lvl 1 C, Data Lvl2 A space, space Data Lvl 2 B space Data Lvl 2 C,Data Lvl3 A space, space Data Lvl 3 B space Data Lvl 3 C.


I really hope you can help me...