columnwise matching of data

[gauranga_25102010]

i have faced lots of problem for matching the data in column and rearrange in row, please help me out,
for example:
CELL
GUW0263

CHGR NUMREQBPC NUMREQEGPRSBPC NUMREQCS3CS4BPC TN7BCCH EACPREF
0 SYSDEF 0 0 EGPRS

ETCHTN TNBCCH
0 1 2 3 4 5 6 7

CHGR NUMREQBPC NUMREQEGPRSBPC NUMREQCS3CS4BPC TN7BCCH EACPREF
1 SYSDEF 20 0

ETCHTN TNBCCH
0 1 2 3 4 5 6 7

END

<RLBDP:CELL=GUW0281;
CELL CONFIGURATION BPC DATA

CELL
GUW0281

CHGR NUMREQBPC NUMREQEGPRSBPC NUMREQCS3CS4BPC TN7BCCH EACPREF
0 SYSDEF 0 0 EGPRS

ETCHTN TNBCCH
0 1 2 3 4 5 6 7

CHGR NUMREQBPC NUMREQEGPRSBPC NUMREQCS3CS4BPC TN7BCCH EACPREF
1 SYSDEF 15 0

ETCHTN TNBCCH
0 1 2 3 4 5 6 7

END

And i want the output as

cell CHGR NUMREQBPC NUMREQEGPRSBPC NUMREQCS3CS4BPC TN7BCCH EACPREF ETCHTN TNBCCH
GUW0263 0 SYSDEF 0 0 EGPRS 0 1 2 3 4 5 6 7
1 SYSDEF 20 0 0 1 2 3 4 5 6 7
GUW0281 0 SYSDEF 0 0 EGPRS 0 1 2 3 4 5 6 7
1 SYSDEF 15 0 0 1 2 3 4 5 6 7

Please get me some way to solve it

[Jaya Sudha]

Im not clear with ur question yar

[gauranga_25102010]

i wanna change the data fomat from column to row wise

[mmmarks]

can you post sample data with attachment.


changing format from column to row


you can try this,

copy the columns which you want to conver them into rows
then take any empty cell -->right click-->paste special ---> transpose-->Ok

Hope this will help

[gauranga_25102010]

Guys please look in to my attachment and help me in that order.

[gauranga_25102010]

I have a group of workbook that contains same with Columns A to AI.
Each workbook contains one work sheets with the same header row, but from 1 to 20,000 rows.

I need to combine all workshbook to a new worksheet, preferably without including the header row (ROW 1) from each sheet apart from the first sheet.

I would prefer not to need to define an exact number of rows, but perhaps an upper limit would be ok.

Any ideas guys? please help

Regards
Gauranga