Hi folks

This is a sample of my input data

0
TscId = 01
Source = 0,1
Owner = SS7_Stack

1
TscId = 01
Source = 1,1
Owner = SS7_Stack

2
TscId = 01
Source = 2,1
Owner = SS7_Stack

3
TscId = 01
Source = 3,1
Owner = SS7_Stack

4
TscId = 01
Source = 0,2
Owner = SS7_Stack

5
TscId = 01
Source = 1,2
Owner = SS7_Stack


And this is the output i want in excel

0 1 2 3 4 5
TscId = 01 TscId = 01 TscId = 01 TscId = 01 TscId = 01 TscId = 01
Source = 0,1 Source = 1,1 Source = 2,1 Source = 3,1 Source = 0,2
Source = 1,2
Owner = SS7_Stack Owner = SS7_Stack Owner = SS7_Stack Owner =
SS7_Stack Owner = SS7_Stack Owner = SS7_Stack

I havent been able to figure out how to do this on a repeated basis...

i know my post is not upto the standards as expected... but this is a
first time post and its pretty urgent... so pls excuse and pls help

Regards
Pradeep


--
PradeepRed
------------------------------------------------------------------------
PradeepRed's Profile: http://www.excelforum.com/member.php...o&userid=29633
View this thread: http://www.excelforum.com/showthread...hreadid=569771