• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Arrange data from columns to rows

ornshrn

New Member
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
 

Attachments

  • Book11.xlsx
    10.4 KB · Views: 6
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.
 

Attachments

  • chandoo.xlsm
    20.8 KB · Views: 3
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 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
 

Attachments

  • chandoo.xlsm
    20.2 KB · Views: 2
Back
Top