Open space delimited text file and transpose

**bahgia** · 01-10-2010, 02:33 PM

Hi,

I have text with data in series of column as below:

Column 1 2 3 4

sample01 159.3 161.5 148.3 154.6

sample02 160.0 155.5 149.9 160.1

sample03 134.6 147.7 146,3 161.1

The data in column can goes up to 10000 columns and the data in rows can goes up to 200 data.

I want to open the text file and the data will look transpose as below:

Column Sample01 Sample02 Sample03

1 159.3 160.0 134.6

2 161.5 155.5 147.7

3 148.3 149.9 146,3

4 154.6 160.1 161.1

Since ms office 2003 can only show 256 column, can anyone have expertise in macro show me how to open the text file and automatically transpose it?

Thank you.

**martindwilson** · 01-10-2010, 03:34 PM

cross posted on open office forum
http://www.oooforum.org/forum/viewtopic.phtml?t=94058

**bahgia** · 01-11-2010, 12:22 PM

Meaning I don't get help? Waaa...

**martindwilson** · 01-12-2010, 04:17 PM

meaning rule 8!

8. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!