columns datas to row & insert new rows

Dear all,

I have attached an excell sheet. It shows machine names & labour hours. I need to arrange it the below way:-

There should be two columns A & B. All the datas in C,D,E,G,H should be inserted autometically in the such a way so that,

a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11 carrys machine name "A" & b1,b2,b3,b4,b5 carrys the value & b6 to b11 cell carrys the value mentioned c1 to h1 cell value.

Similarly, we should do the same thing to machine no B.

You have a before example, but no after. please post a sample of what the data is to look like after it has been manipulated.

I have attached a sample how it would be look like. But I have given the sample for machine name "A" only. Machine name "B","C","D" could be changed in the same manner as done for "A".

Hope now its clear.

please suggest.

The following will place the manipulated data on Sheet2

Please Login or Register  to view this content.