How to easy transpose the table to want form?

[flying008]

Dear all, hello !

this is import data.

RecordID	XML
1	Retailer
2	Order No.
3	Invoice Number
4	Contact Date
5	Count
6	Item Description Description
7	CA123
8	12345
9	147249
10	20151221
11	50
12	[51423]
13	BB174
14	47119B
15	141149
16	20151208
17	50
18	[73892] 5th Gen & Ipad Cover
19	MN149
20	47233A
21	147209
22	20151023
23	50
24	[378293] Xbox Controller

Below is my want result from transpose:

Retailer	Order No.	Invoice Number	Contact Date	Count	Item Description Description
CA123	12345	147249	20151221	50	[51423]
BB174	47119B	141149	20151208	50	[73892] 5th Gen & Ipad Cover
MN149	47233A	147209	20151023	50	[378293] Xbox Controller

How can do this by a simple way to transpose? thank you !

[SPetrie · Accepted solution]

Are you able to use the XML parse tool before it gets to this point? That may be the easier route.

If not, assuming the headers and data are always in 6 columns, you could do it this way.

[flying008]

Hi,@SPetrie 

Actually it's not XML content. Thanks a lot for your answer, I also think of another solution.

[SPetrie]

I always forget about the tile tool. I like your solution better :)