How to split data?

[Jia_Qi]

My current data after using image reader and Tesss4j:

Driver Name Status

John
Andrew
Samuel
William
Lucas
Gabriel
Benjamin
Daniel
Henry
Kevin

Active
l nactive
l nactive
l nactive
Active
Active
l nactive
Active
Active
Active

Driving License Expiry Date Vocational License Expiry Date Transport Type

2024706730 0:00:00
2024707731 0:00:00
2024708731 0:00:00
2024709730 0:00:00
2024710731 0:00:00
2024711730 0:00:00
2024712731 0:00:00
2025701731 0:00:00
2025702728 0:00:00
2025703731 0:00:00

2025701731 0:00:00 Van
2025703731 0:00:00 Van
2025705731 0:00:00 Bus
2025707731 0:00:00 Van
2025709730 0:00:00 Bus
2025711730 0:00:00 Bus
2026701731 0:00:00 Van
2026703731 0:00:00 Van
2026705731 0:00:00 Van
2026707731 0:00:00 Bus

How can I split the data into column with proper data cell like this:
Excepted outcome:

[ScottF]

As best I can tell, your post is basically the same as what’s in this other thread:

How to split data cell?

Currently I have user image reader to read the image and extract the data. Now, how can i split and organize the data properly? For example, a new column for Driver Name, new column for status and so on. [image] The final output should same as this table: [Screenshot 2025-05-21 171154]

Not sure if you posted this under two different names, or you both are working on the same assignment, or something else.

At any rate, I’ll close this thread to keep the forum tidy - let’s keep the discussion going over there.