Notifications
Clear all
Power Query
5
Posts
3
Users
0
Reactions
136
Views
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
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
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
Thanks for the feedback
Posted : 08/06/2025 2:19 am