clip

  1. J

    Dropdown list multiple column

    Hi please need a help. I have a excel sheet as given below. I need to make a drop down list of that, when I select item name from the dropdown list , item code also come in the next column. Is it possible . Sheet1 <thead> A B </thead><tbody> 1 Item Name Code 2 TRIM CLIP ON LED PANEL 6W...
  2. J

    Combine 2 column in pivot table

    I have an excel sheet as given below. I want to name and address column in pivot table. If it is possible Sheet1<thead> A B C D E F G H I J </thead><tbody> 1 INVOIVCE NO INVOICE DATE CHELLAN NO PARTY NAME ADDRESS ITEM NAME ITEM CODE HSN QTY TYPE 2 5622218065 15/11/18 Samsung Mussaffa...
  3. S

    Move rows into columns

    Hi I want to move a lot of rows into columns Here is attached a small clip what I need https://www.screencast.com/t/ATXeMzkNi Can somebody help me?

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top