View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hardeep_kanwar[_2_] Hardeep_kanwar[_2_] is offline
external usenet poster
 
Posts: 103
Default Transpose Column to Row

Hi! Expert

http://www.savefile.com/files/1783586

I think is really Challenging

I have data about 9000 and I want to Convert the data of Columns E: E and F:
F into Rows.

My problem is that in B: B there are Customer Code and in C: C is the
Network name and in D: D is the Propname.

There is only one DBCode against each NETWORKNAME. But one or more than one
or it may go to 10 Propname.

Now I want to Transpose data of E: E i.e. Child name into rows.

Sheet 2 is the example of my question.


Thanks in Advance

Hardeep kanwar