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

ComiFly

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

<colgroup><col></colgroup><tbody>
</tbody>
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
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?
 
Upvote 0

Forum statistics

Threads
1,214,593
Messages
6,120,435
Members
448,961
Latest member
nzskater

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top