combine single column text files

[tbrowning]

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

File 2

Field1=Value4
Field2=Value5
Field3=Value6

File 3

Field1=Value7
Field2=Value8
Field3=Value9

I can get the data to look like this:

Column1	Column2
Field1	Value1
Field2	Value2
Field3	Value3
Field1	Value4
Field2	Value5
Field3	Value6
Field1	Value7
Field2	Value8
Field3	Value9

But I can't figure out how to make it look like this:

Field1	Field2	Field3
Value1	Value2	Value3
Value4	Value5	Value6
Value7	Value8	Value9

Does anyone have any advice?

Thanks,

Tom

[tbrowning]

Ahhh of course, I kept trying pivot but without the file name, and thus it was aggregating things. Thanks!

[AlexisOlson]

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: