transpose

  1. N

    VBA: Transfer & Transposing

    Would like some help with a VBA script to transfer data as shown below. I tried to make it as simple as possible below. Sheet1: COL G-M may not always contain complete data. Therefore, only transfer the cells with actual data as a new row. See Sheet2 for how it is to look. The final result is...
  2. J

    SUMPRODUCT & TRANSPOSE - Array

    Hi, I was hoping someone could help me find a way to avoid using an array formula for the following problem. I have two tables: Table 1: Table with hours per month, where rows are specified with department and labor category. Table 2: Table with hourly rates per month, where rows are...
  3. K

    Transposing cell contents from one sheet into another sheet with different order/format

    Hi! First time poster, and absolute amateur at Excel 😓 I've been trying to work this out for a while but I really don't know where to begin, so apologies if this has been asked in other terms. I need help transposing the contents of one sheet into another sheet where the columns and rows are...
  4. E

    Arrange (Transpose) Single Row to Multiple Row Based on Criteria

    Arrange Single Row to Multiple Row Based on Criteria Hi Friends, I have Product Data in Single Row in following order (data in tabular form at end of sheet) Above data is required to be sorted in new sheet as following 1. Row number 2,3,4, are for refrence only. Not Required In actual...
  5. R

    Transpose rows for a single column based on equal value in other columns

    Hi, so I am trying to transpose the values of a single column into 3 seperate columns if all the other columns values are same. This is what my initial data looks like: I want the data of column A split into column headings, right now it has 3 unique values: Batch1, Batch2, Batch3. And I want...
  6. K

    Transpose date from rows to columns for multiple rows using macro

    Hi I have a set of data i need to transpose hopefully with the use of a macro if possibly. Any other way would be helpful too but I dont really see how to get this done. This is what my data looks like: And this is what I want it to look like after: Hopefully someone can help me. Thank you
  7. D

    Transpose Large Data Help

    Morning, Hoping someone might have knowledge that may help me. I have to run a data pull every month. It comes in a certain format, and I need to transpose it into another format. I understand the transpose part, but only for a single set of data. My data is about 6000 rows long. This is the...
  8. D

    Copy cells from files in the loop and paste them transposed to MasterFile.

    Hello everyone, I have a macros which loops through multiple workbooks (csv files) in a folder C:\VBA\, and makes changes to numerical values of each file, as a result of changes the value of the certain cells in the column “M” becomes (while the code is still processing CSV file) equal to BUY...
  9. S

    Merging contact info from different exports (sticking point: phone/address/email type column + 1 data column vs. multiple data columns)

    I'm working with some seasoned realtors that are looking to combine their client data for an import into their CRM, one realtor has data that is stored in iCloud, Yahoo, and Gmail, which are exported to separate CSV files. The trouble is that the exported phone numbers, email addresses, and...
  10. A

    Transposing certain rows to columns, on to a new sheet, based on different criteria.

    Hi, Hope someone can really help me as I have been struggling and not getting any where with this and my current solution is going to take me days to complete. I have a cashflow for a number of projects, and each project has 7 different types of cashflow all going horizontal. However, as we...
  11. C

    VBA Code to Insert Variable # of Rows to be Added Below Data So All data sets have Same Number of Rows

    Hello, I'm new to VBA but would like to see if anyone could help me with my VBA code. Attached is a screenshot of the expected result. Process: I copied column from an online index which has variable number of rows per individual. In order to transpose the data and align data properly, each set...
  12. C

    Bulk Transpose a formatted column help

    Hi All, New to the site, but you all come highly recommended by a coworker. Hoping you can steer me in the right direction on this.. We have an old PBX phone system at work, where when the data is exported it's usually in a single column text document. I'd like to be able to take the data and...
  13. M

    Filter/Transpose a multiple rows and multiple columns in a same row.

    Hi, Required a formula help for Filter/Transpose a multiple rows and multiple columns in a same row as per condition met with row headers . Row Headers that contain duplicate row headers and reorder all values or text values from multiple columns into one row. solution to be needed in Column...
  14. D

    Easy VBA but stumped why it won't work as expected

    Hey Folks, Someone decided on a terrible way to record attendances which I would like to remedy. As you can, hopefully, see below, I would like to translate this into a proper spreadsheet format with column A for Name and column E for Date attended. I have some simple code which should loop...
  15. S

    Need to Transpose these 1 to 6 columns into one single Column (multiple rows),Keeping the left 2 columns intact. Please help!

    Company Name Count of Names 1 2 3 4 5 6 Deco-Mica Ltd 4 Deco Mica Ltd Deco-Mica Ltd Deco Mica Deco-Mica Bharat Textiles & Proofing Industries Ltd. 4 Bharat Textiles & Proofing Industries Ltd Bharat Textiles & Proofing Bharat Textiles & Bharat Textiles Sainik Finance & Industries...
  16. dreen

    Using Find and Resize to transpose values error

    I am trying to take my current code, that uses a Find function to search for the value in cell "H4" (this value is in the worksheet where the code is) and find it in a second workbook searching from Columns A3-A100000 (Find functions start at the next row after the first, hence why in my code I...
  17. J

    Rows of data from columns - not simple transpose.

    Hi, I'm sorry if I don't follow all of the rules as this is my first post, I may have missed some of them, My current problem is I need to create one line of data from the table below, which contains a lot more data than just shown below, but as an example, I need to transform the data into one...
  18. K

    Rearrange / Transpose data, cases dividend by white row

    Hi all, I’m kind of a excel newbie so I tried to get the answer by searching the web but I can’t figure it out. I have a question regarding transposing my data. Al my data is vertical like this: Every case is separated by an empty row. I want to pivot the data per case. That it looks like...
  19. G

    Transpose every X rows to columns (Automation)

    Hello, I would like to transpose a range of data (A1 to KJ1) from every second row (row 1, row 3, row 5, until the last row) under one single column (e.g. column C) in the same sheet. I am having difficulty creating a macro with a loop that will help me do this. I tried following some...
  20. B

    How to change Pivot Format

    I have data of image links in excel. Some of my SKUs have 2-3 images. But the problem is all of them are in different rows. I want my images to be displayed as Main SKUs in Rows and their multiple image links in columns in front of them. Please help, Thanx. Raw Data Main SKU Image Links...

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