Arrange data from columns to rows

[ornshrn]

Hi,

How can I arrange data that is ordered one under the other to side by side. The trick is, only for data that is related to the same Key item?

I have attached an example.

And one more question, do you have tip/s how to find a solution among all the knowledge we have in this forum? like the one I have asked above.

Thanks
Oren

 

[Mike H..]

Hi,

How can I arrange data that is ordered one under the other to side by side. The trick is, only for data that is related to the same Key item?

I have attached an example.

And one more question, do you have tip/s how to find a solution among all the knowledge we have in this forum? like the one I have asked above.

Thanks
Oren

Hi,

See your attached file. data are copied to new worksheet.

To find help here then you should first use the SEARCH facility at the top right of the window.

 

[ornshrn]

Hi Mike,

Thanks a lot! Do you know how do it without VB but based on excel's formulas? I am not that strong in VB

About searching..I meant for content, how to find something specific in a huge data base. Do you recommendations of your own?

Thanks
Oren

 

[Mike H..]

Hi Mike,

Thanks a lot! Do you know how do it without VB but based on excel's formulas? I am not that strong in VB

About searching..I meant for content, how to find something specific in a huge data base. Do you recommendations of your own?

Thanks
Oren

Hi,

I don't think a problem like this is best solved with a formula but the attached may be what you want.

I'm not sure I follow your meaning about searching. If you put a specific term in the search box then you should be able to get help

 

[ornshrn]

Hi Mike,

It works perfectly!

Thanks
Oren