transpose

I have a list of items which are scattered, I need them all in one column, the items scattered can be brought into one column withing the blank cells. This is what i need. some times there is 2 values to transpose, sometimes 5 or sometimes no need, So i dont know how to achieve it. Sub...

Hi I've been looking at a lot of transpose demos, still can't get what I need to do this so let me explain. I have a four column table and I am looking to Transpose it over to a two column table or array? It will reuse the column headers so I'm thinking a loop for them and a counter to...

I was sent a spreadsheet, but reading the information is difficult in a horizontal format. It needs to be vertical. I need to be able to transpose it, but I need it to be in a two-column formation. The information came to me like this: Part Qty Part Qty Part Qty Part Qty Aisle 1 Bananas 1...

Hi, I'm trying to filter the columns that appear in a chart. I've been through a number of methods to achieve this, but the most practical seems to be a named range using =filter(tranpose()) (and tranpose back if needs be), but what would I put in the filter argument? The cell references...

Hi everyone, I am an Excel beginner, with basic knowledge. I am collecting Australian Football Data into Excel. I've gone through what the process is like below. I want to know how I can make this process more efficient and automated? Can I utilise a macro or something else that can copy...

Hi, I would like to find a way to put all of the data relating to one ID into one row. Below is a simplified example of the data I have. I have tried to use a pivot table, however it does not take kindly to the text values. What would be the most efficient way to do this, if it is at all...

Hi, I would like a VBA that will transpose the data set like this below. I am at a loss of where to start. I am good with VBA for the basic excel functions but I learn by reverse engineering things. Columns A,B,C is how I am starting, I want to finish with it looking like Columns F and beyond...

Hi everyone! I've been trying to create a script for this one for several days now but I keep failing. Here is my data. Tab 1 is the raw data Tab 2 is how it should look. The idea is to transpose values but create a new row once the word 'Skip' shows up. Any idea how to do this? I really...

Hi. I have problem with excel but i cant explain. please help me

Hi All, I have a little bit of VBA knowledge but am struggling with this one. I have a data extraction from an accounting system. The first half of the data is represented horizontally as expected, but the second half of the data is somehow expressed vertically (a can of worms I don't need to...

Hi All, I am wondering if anyone could help me please? I have been given a folder called "CPET" which contains an number of workbooks which all of which have unique data but on the same rows and columns for each work book (please see the picture below). I have been asked to put all this data...

Hi All i have a simple spreedsheet setup for my daily work priority list. you enter data on sheet1 (Data Entry) hit submit and it goes to Sheet 2(DataBase) Private Sub CmbSubmit_Click() Dim srcSht As Worksheet, destSht As Worksheet Dim srcRng As Range, destRng As Range Set...

Hi All, i currently use a code to tranpose data from Column B Data Entry (sheet1) to Database (sheet 2) using a cmdbutton Private Sub CmbSubmit_Click() Dim srcSht As Worksheet, destSht As Worksheet Dim srcRng As Range, destRng As Range Set srcSht = Worksheets("Data Entry")...

Hi all, I currently have a data set that looks like this: I would like to transpose my information down under columns H-L so that for ALL cells in A that contains "George", their respective cells in columns B-F will be transposed under column H. Likewise the same for all cells that contain...

So I am looking to make a button that when pressed, the macro will cut the values/ words (not the formatting, as this column has drop down lists) from worksheet 1 (Data Entry), and paste them onto worksheet 2 (Locked) in rows. I don't want it overriding the existing rows in worksheet 2, rather I...

I need to use power query to bring the initial format to this format that i have mentioned later, i've tried Merging, Transposing, Promoting Headers and Unpivoting Columns but somehow i'm messing up somehwere. Also need to remove the Random digit values in C column from row 4 to 6. Here's the...

Hello, I have a table that contained, below, I want to transform table like this, is that possible to make with vba or using formula? Thanks for your help. Original table below: Line_Name Stock_code 22.06.2022 23.06.2022 24.06.2022 K9-CMF1 TUBE GUIDE 9813924080 1725 1976 1579 K9-CMF1...

Need help regarding how I can copy the data from different columns having some cells with no data into a single column ignoring the empty cells...

Hello, I have some code that I'm struggling with that works fine as simple formulas but doesn't want to work at all as code. The code is simply a countifs from a range counting if values match 2 different given conditions. But for some reason the countifs doesnt actually return any values. Both...

This is the source format i have which i have tried picoting and unpivoting and even transposing for some reason to make it work in the format i have attached below i have even reached a point where my excel looks almost like the output but then the batch numbers are missing...