transposed

Hi MrExcel expert, I really appreciate your help to solve this issue. I have been working on this issue for a couple of days now and I feel stuck. Data set: Hours & Date. Goal: 1. I want to sort the data of "date and hours" which have hours assigned to them, and listed beside of my existing...

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)...

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...

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...

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>...

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>...

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...

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!

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...

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...

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...