converting columns to rows

R

rathika

hi

i have a table with columns and records like this

Fields Record 1 Record2

employeename tom ian
month june june
Stage1-Penthouse 10 20
Stage1-Beachclub 15 25
Stage3-Penthouse 30 45
Stage3-Beachclub 50 90

but i want my table and records to be like this

Fields Record 1 Record2 record3 record4

employeename tom tom Ian Ian
month june june june June
Item Penthouse Penthouse Pthouse Phouse
Stage 1 3 1 3
No.of hrs 10 30 20 45


and so on like this

pls. help me how do i do this . this is very urgeant for
me

rathika
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dobule level break 1
Excel Formula for years and months 2
Remove lines from text file prior to importing in Excel 2
Display Records in columns 7
Multiple records per row in a continuous form 1
Charting based on a specific month in a column 1
Query that autonumber some columns 3
How to loop thru cells in a row 2

Top