Using Excel Text to Column

Help Studio
, ,
1

I have generated a DataTable with 100’s of names and sorted to a text file;
Fomatted as example below:
Albert
Albert
Albert
Albert
Albert
Bryan
Bryan
Bryan
Paul
Paul
Paul
I want put the same names in one column and create different columns for each set of names
Column1 Column2 Column3
Albert Bryan Paul
Albert Bryan Paul
Albert Bryan Paul
Albert
Albert
I compare previous name to current name and when they differ I will generate the new column all with the same name
I have tried several ways to accomplish the excel column issue to no avail. I assume I need a column index variable. The only activity I see now applicable is Text to Columns but I am having trouble understanding how it works. If someone has an example, it would be most appreciative… Thanks

The image shows the "Text to Columns" dialog box in Excel, where various settings such as source range, destination, data type, delimiter, and other options can be configured. (Captioned by AI)
The image shows the "Text to Columns" dialog box in Excel, where various settings such as source range, destination, data type, delimiter, and other options can be configured. (Captioned by AI)525×380 9.96 KB

I assume Text to Columns will allow me a column index variable to do this but if there are other methods please share.

2

Hi,

How about the following sample?

image
image1070×2018 138 KB

Sample
Sample20241127-1.zip (3.4 KB)

Regards,

3

Wow!

Yoichi, Thanks very much. I learned a lot from your example

Regards

1 Like