transpose

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

We have a mess... We are using the newest version of excel on windows platform and have a massive list of email addresses that are unfortunately combined into one column in excel, the largest combination containing 157 email addresses in one column cell. Our objective is to move all of the...

Good night everyone, I have a list of data all in one column that I need to separate in several columns. Raw source: Column A Text 1 Text 2 Text 3 ... Tex 8 Text 1 Text 2 Text 3 ... Tex 8 Text 1 Text 2 Text 3 ... Tex 8 up to 7,000 lines. I would like something like this: Column Text 1...

I need help, I'm on a MAC and don't know how to use VBA's. Previously I would have used MS Access, but.... Mac! Here is what my data looks like: PDP URL IMAGE URL IMAGE ALT TEXT abc.com/page1.html abc.com/images/banana.jpg Banana abc.com/page1.html abc.com/images/apple.jpg Apple...

I currently have a list of clients where in some cases, the clients have multiple client numbers which are in different columns. I need to move those with multiple client numbers to have the client number on it's own row. My dataset currently looks like this: CLIENT CODE 1 CODE 2 CODE 3 CODE...