Transforming Data from a single colum
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JingYih_Herbalife
8 - Asteroid
‎01-29-2022
04:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a data copied from web that comes out in one column when I transfer to excel.
Would like to transform the data into below
Appreciate very much some guidance as this is quite a complicated one for me.
Labels:
- Labels:
- Datasets
7 REPLIES 7
12 - Quasar
‎01-29-2022
06:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you missing a ":" and a value of registered voters on line 7? 110924 I assume?
‎01-29-2022
06:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
12 - Quasar
‎01-29-2022
07:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-29-2022
09:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for that solution above @Watermark . Great learning the different tools that were used.
The data above is using the constituency number as a field. If for instance I have multiple constituency, how do I move forward?
For instance I want to transform the below to
Desired output:
Thanks for your guidance.
binuacs
21 - Polaris
‎01-29-2022
09:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎01-29-2022
09:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎01-30-2022
04:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
