Split Column data in power query at each Capital letter into separate columns

[ComiFly]

[TABLE="width: 199"]
<colgroup><col></colgroup><tbody>[TR]
[TD]HoltsvilleIRS[/TD]
[/TR]
[TR]
[TD]San JuanWest[/TD]
[/TR]
[TR]
[TD]San JuanEast[/TD]
[/TR]
[TR]
[TD]Virgin Islands[/TD]
[/TR]
[TR]
[TD]*San JuanMain[/TD]
[/TR]
[TR]
[TD]SpringfieldVicinity[/TD]
[/TR]
[TR]
[TD]*SpringfieldMain[/TD]
[/TR]
[TR]
[TD]Pittsfield[/TD]
[/TR]
[TR]
[TD]Greenfield[/TD]
[/TR]
[TR]
[TD]Fitchburg[/TD]
[/TR]
[TR]
[TD]WorcesterVicinity[/TD]
[/TR]
[TR]
[TD]*WorcesterMain[/TD]
[/TR]
[TR]
[TD]Framingham[/TD]
[/TR]
[TR]
[TD]Woburn[/TD]
[/TR]
[TR]
[TD]Lynn[/TD]
[/TR]
[TR]
[TD]BrocktonWest[/TD]
[/TR]
[TR]
[TD]BostonMain 1[/TD]
[/TR]
[TR]
[TD]BostonMain 2[/TD]
[/TR]
[TR]
[TD]BrocktonEast[/TD]
[/TR]
[TR]
[TD]Lexington[/TD]
[/TR]
[TR]
[TD]Cape CodWest[/TD]
[/TR]
[TR]
[TD]Cape CodEast[/TD]
[/TR]
[TR]
[TD]†Providence (RI)East[/TD]
[/TR]
[TR]
[TD]ProvidenceWest[/TD]
[/TR]
[TR]
[TD]*ProvidenceMain[/TD]
[/TR]
[TR]
[TD]ManchesterVicinity[/TD]
[/TR]
[TR]
[TD]*ManchesterMain[/TD]
[/TR]
[TR]
[TD]Waterville Valley[/TD]
[/TR]
[TR]
[TD]*Concord[/TD]
[/TR]
[TR]
[TD]Keene[/TD]
[/TR]
[TR]
[TD]†Littleton[/TD]
[/TR]
[TR]
[TD]†Bellows Falls (VT)East[/TD]
[/TR]
[TR]
[TD]†White River Junction (VT)East[/TD]
[/TR]
[TR]
[TD]PortsmouthWest[/TD]
[/TR]
[TR]
[TD]†Portsmouth (NH)East[/TD]
[/TR]
[TR]
[TD]PortlandVicinity[/TD]
[/TR]
[TR]
[TD]*PortlandMain[/TD]
[/TR]
[TR]
[TD]Auburn[/TD]
[/TR]
[TR]
[TD]Augusta[/TD]
[/TR]
[TR]
[TD]Bangor[/TD]
[/TR]
[TR]
[TD]Bath[/TD]
[/TR]
[TR]
[TD]Ellsworth[/TD]
[/TR]
[TR]
[TD]Houlton[/TD]
[/TR]
[TR]
[TD]Rockland[/TD]
[/TR]
[TR]
[TD]Waterville[/TD]
[/TR]
[TR]
[TD]White River JunctionWest[/TD]
[/TR]
[TR]
[TD]Bellows FallsWest[/TD]
[/TR]
[TR]
[TD]Bennington[/TD]
[/TR]
[TR]
[TD]Brattleboro[/TD]
[/TR]
[TR]
[TD]Burlington[/TD]
[/TR]
[TR]
[TD]AndoverIRS[/TD]
[/TR]
[TR]
[TD]Montpelier[/TD]
[/TR]
[TR]
[TD]Rutland[/TD]
[/TR]
[TR]
[TD]St. JohnsburyWest[/TD]
[/TR]
[TR]
[TD]St. JohnsburyEast[/TD]
[/TR]
[TR]
[TD]HartfordVicinity[/TD]
[/TR]
[TR]
[TD]*HartfordMain[/TD]
[/TR]
[TR]
[TD]Willimantic[/TD]
[/TR]
[TR]
[TD]New London[/TD]
[/TR]
[TR]
[TD]New HavenVicinity[/TD]
[/TR]
[TR]
[TD]*New HavenMain[/TD]
[/TR]
[TR]
[TD]*Bridgeport[/TD]
[/TR]
[TR]
[TD]Waterbury[/TD]
[/TR]
[TR]
[TD]StamfordVicinity[/TD]
[/TR]
[TR]
[TD]*StamfordMain[/TD]
[/TR]
[TR]
[TD]NewarkVicinity[/TD]
[/TR]
[TR]
[TD]*NewarkMain[/TD]
[/TR]
[TR]
[TD]Elizabeth[/TD]
[/TR]
[TR]
[TD]Jersey City[/TD]
[/TR]
[TR]
[TD]PatersonVicinity[/TD]
[/TR]
[TR]
[TD]*PatersonMain[/TD]
[/TR]
[TR]
[TD]Hackensack[/TD]
[/TR]
[TR]
[TD]Red Bank[/TD]
[/TR]
[TR]
[TD]Dover[/TD]
[/TR]
[TR]
[TD]Summit[/TD]
[/TR]
[TR]
[TD]Cherry Hill[/TD]
[/TR]
[TR]
[TD]Camden[/TD]
[/TR]
[TR]
[TD]Atlantic CityVicinity[/TD]
[/TR]
[TR]
[TD]Bridgeton[/TD]
[/TR]
[TR]
[TD]*Atlantic CityMain[/TD]
[/TR]
[TR]
[TD]TrentonVicinity[/TD]
[/TR]
[TR]
[TD]*TrentonMain[/TD]
[/TR]
[TR]
[TD]Lakewood[/TD]
[/TR]
[TR]
[TD]New BrunswickVicinity[/TD]
[/TR]
[TR]
[TD]*New BrunswickMain[/TD]
[/TR]
[TR]
[TD]MilitaryBases in DE[/TD]
[/TR]
[TR]
[TD]MilitaryBases in DE[/TD]
[/TR]
[TR]
[TD]MilitaryBases in DE[/TD]
[/TR]
[TR]
[TD]MilitaryBases in IQ, AF, other[/TD]
[/TR]
[TR]
[TD]MilitaryBases in UK[/TD]
[/TR]
[TR]
[TD]MilitaryNaval/Marine[/TD]
[/TR]
[TR]
[TD]MilitaryBases in ES, IT[/TD]
[/TR]
[TR]
[TD]MilitaryBases in EU, GL, CA[/TD]
[/TR]
[TR]
[TD]MilitaryAfrica/Middle East[/TD]
[/TR]
</tbody>[/TABLE]

 

[gazpage]

This help?

https://www.mrexcel.com/forum/power-bi/937160-power-query-split-columns-capital-letter.html

 

[ComiFly]

Thank you. I had seen the information in the link you provided. However, I wanted to understand how I can list the column by column name instead of putting each of the items in the column in quotes " ". As an example, let's say the column name that the information above is "countries". How would I add this to the first line "

source = Table.FromColumns({ {"Robert DuvallCrime", "TabuDrama"} }, {"text"}),​

provided in the link?