transpose

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi All, I am attempting to take a table like this: and transposing the "Loss Used" amounts so they are transposed to give each "Loss Year" row a horizontal breakout of when these amounts were actually used. The output should look something like below: Right Now those are static linked...

Hi guys, need help finding VBA code for this. Please see pictures attached. For example (Picture 1) IF I input 5 in (Sheet 1, Range C4), THEN the values in Sheet 1 under Row 8 should replace the values in Sheet 2 at the right side of special code 5, since the special or unique codes matched...