Pivot/transpose data

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

vikrambarthwal
Posts: 1
Joined: Sat Oct 18, 2008 9:31 pm

Pivot/transpose data

Postby vikrambarthwal » Sat Oct 18, 2008 9:54 pm

I have data like this in ascii Text format :

SrNo.1 Name1 Name 2 Address1 Data1 data 2
Address2
Address3
Address4
Address5
Address6

SrNo.2 Name1 Name 2 Address1 Data1 data 2
Address2
Address3
Address4
Address5
Address6
SrNo.3 Name1 Name 2 Address1 Data1 data 2
Address2
Address3
Address4
Address5
Address6

The address rows sometime varies from 6 to 8
I want all the addresses from Adress2 to 6 in the same data row which has name1, name2, address1,Data1 & data2

i.e i want it as follows:

SrNo.1 Name1 Name 2 Address1 Address2 Address3 Address4 Address5 Address6 Data1 data 2
SrNo.2 Name1 Name 2 Address1 Address2 Address3 Address4 Address5 Address6 Data1 data 2
SrNo.3 Name1 Name 2 Address1 Address2 Address3 Address4 Address5 Address6 Data1 data 2


Thanks

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Please Help ??

Postby DataMystic Support » Tue Oct 21, 2008 9:10 am

Best option here is to replace spaces with commas to convert it to CSV format, then use the attached filter to pivot/transpose the text.
Attachments
pivot csv file.zip
(836 Bytes) Downloaded 326 times


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 4 guests