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...
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...