Forum

Splitting a Column ...
 
Notifications
Clear all

[Solved] Splitting a Column with codes and below the code numbers

5 Posts
3 Users
0 Reactions
136 Views
(@hutchdjr)
Posts: 19
Eminent Member
Topic starter
 

I am trying to split a column which has a code which has text & numbers and below this code a list of numbers. This repeats down the column. I want to put the codes in one column and the numbers in another.

example

HH23

2

3

4

ABD 235

4

5

6

DDFF

6

22

55

 

 
Posted : 05/06/2025 12:30 am
Riny van Eekelen
(@riny)
Posts: 1243
Member Moderator
 

@hutchdjr

How exactly? Numbers in one column and the codes in the next column filled down, or just in the same row?

Perhaps the attached file will help you on your way. If not, please come back here with an example of your file and the desired result.

 

 
Posted : 05/06/2025 2:20 am
Alan Sidman
(@alansidman)
Posts: 229
Member Moderator
 

Here is an alternative Power Query Solution

 

 
Posted : 06/06/2025 8:23 am
(@hutchdjr)
Posts: 19
Eminent Member
Topic starter
 

Thank you very much, both options work for me. (Sorry for not getting back to you sooner. Our IT blocked my work computer from accessing this website)

 
Posted : 08/06/2025 1:38 am
Alan Sidman
(@alansidman)
Posts: 229
Member Moderator
 

Thanks for the feedback

 
Posted : 08/06/2025 2:19 am
Share: