Forum Discussion
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
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
2 Replies
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:
Ahhh of course, I kept trying pivot but without the file name, and thus it was aggregating things. Thanks!
