vertical to horizontal

  1. A

    How to increase cell number reference horizontally??

    I'm pulling an ID from a seperate Workbook that lists the the IDs in Column D vertically. I have a sheet that I need to copy these ID's to, but the formatting goes horizontally. For example, Assignment 1 Assignment 2 Assignment 3...
    • arooney88
    • Thread
    • copy & past rows skip multiple cells vertical to horizontal
    • Replies: 4
    • Forum: Excel Questions
  2. L

    Excel Data Manipulation - Transpose

    HiI need to transpose some data as follows, for which a normal transpose doesn't seem to work.I have cost centre in column A, Account Code in column B, Description in column C, and then column D to O has values phased by month (Jan-Dec) with headings in row 1.What I want is to transpose this so...
    • ls010s
    • Thread
    • excel data manipulation transpose vertical to horizontal
    • Replies: 9
    • Forum: Excel Questions

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
Back
Top