transposed

  1. J

    Copy and paste transposed - help please

    I am relatively new to this so please have patience. I have an excel spreadsheet with about 150,000 values in column A (so A1 to A150000). I need to copy 10 of them and then paste them transposed into the 10 columns to the right (B through K). Currently I am selecting the 10 (A1 to A10)...
  2. L

    Array formula

    Hi, I'm trying to use a formula I've used before but not it's giving me a reference error. I'm trying to move the data from sheet two over into sheet one so that instead of being on a single row it gets transposed into the column where Column A matches for both sheets. The formulas I was using...
  3. D

    Sumifs where columns are transposed and contain duplicate labels

    How can I do a SUMIFS (or similar) where columns/rows are transposed and columns have the same label (like B&D below). In my data sheet data is organised like: <tbody> 3100 3587 3100 3800 Talent 200 320 124 256 Sourcing 90 77 85 784 Media 45 69 30 941 Talent 426 25 24 4256 Sourcing...
  4. D

    Sumifs where columns are transposed

    How can I do a SUMIFS (or similar) where columns/rows are transposed. In my data sheet data is organised like: <tbody> 3100 3587 2568 3800 Talent 200 320 124 256 Sourcing 90 77 85 784 Media 45 69 30 941 Talent 426 25 24 4256 Sourcing 497 74 85 287 Media 569 36 26 365 </tbody>...
  5. S

    VBA Frequency Transposed

    I have a set of data in column A that I would like transposed using VBA. I would like to put the data under the proper bin. Bins are 0-64, 65-72, 73-82, 83-90, 91-100. <table class="tableizer-table"> <thead><tr class="tableizer-firstrow"><th>20</th></tr></thead><tbody> <tr><td>37</td></tr>...
  6. G

    sum/sumiif on transposed range

    I have a set of data in rows but on the next sheet i need to sum the info depending on the options i have chosen what formula should be used? example below Sheet 1 Option price A 5 B 10 C 20 D 17 E 30 Sheet 2 Option option A D...
  7. Z

    Help with Transposing Defined Table

    Hi, I have a defined table in cells A5:B9. Every week, I am adding another row. Is it possible to place a transposed version of this table in C1 that updates automatically? Thanks!
  8. D

    Trying to correct erroneous values being used by =Combinations array

    In Worksheet1 I have a small table (AK28:AZ28) of numbers which have been established via a calculated event (example: the formula in AK28 is =IF(OR(AK25="X",AK24=""),99,AK24)). AK24 would either equal a number (1-20 or 99) or an X. The "X" represents the number has already been use, the 99...
  9. P

    Dynamic XIRR (OFFSET) Transposing Formula Help

    Hi, I am trying to calculate XIRR using dynamic ranges. I found the solution in the attached URL but the data and formula would need to be transposed into a new format (according to how my model is built). Are you able to help me reconstruct the formula according to how I have my data...
  10. M

    Copy each employee row that matches the sheet name into column G transposed

    Hi, i am very new at Vba. I not sure I can even do this. I've tried in a macro but it didn't work. I have a file there are multiple sheets included. One sheet contains a list of employees - that are listed in rows. There are 200+ tabs (5 to exclude), each sheet named with the employee...

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