Forum Discussion

tbrowning's avatar
tbrowning
New Member
3 years ago

combine single column text files

Hi all,   I have a folder with plain text files that I want to transpose into a table.   Let's say I have three text files, as follows:   File 1   Field1=Value1 Field2=Value2 Field3=Value3 ...
Need Help
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
3 years ago

You can do this with a pivot operation, but you need a bit of extra information.

 

If you can get the data in a format like this:

 

Then you can finish with a single GUI operation: