transpose

I have below row data shown as below in sample and I want a formula to populate expected results shown ABCDEFGHIJK1Row DataExpected Result2NameCourse Name 1Course Name 2Course Name 3Course Name 4Course Name 5NameCourses3Name 1Course1Course2Name 1Course14Name 2Course1Name 1Course25Name...

Hi, I need your help to change the format of Table#1 to Table#2 Table#1 (raw data) Project Name Staff Name Project 1 John Project 1 Jess Project 1 Jack Project 2 Ann Project 2 Jess Project 2 John Project 2 Pete Table#2 (Required format) Project Name Staff Name 1 Staff...

Context I have an ever growing collection of 200+ paged pdf documents that contain bank checks. The checks themselves will not scan into Power query, however their header's will. My goal is to extract the header of each check statement and then transform that information into a row that would...

Hi , I want to convert 5 rows data set into 1 row till last record. Note - 1. Range ( A1:F15 ) is only for example and it can change in the actual data ,Hence I required dynamic range selection to avoid manual changes in the range every time. My Data Output Required:-

Hi, I am using the below formula though I need the results to skip 3 cells each time, therefore the results to appear in cells A1, D1, G1, J1 etc. =UNIQUE(TRANSPOSE(Data!I4:I13)) Can someone help please?

what is the best way to transpose this data? I am spending so much time formatting when all the data is there just not how I need it.

Hello, I need your support in creating a vba and transposing data into another sheet Original sheet from where the data is needed to be copied ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAY1rate zone coderate zone nameorigin addressdestination addresscurrency1...

Hi I have a list of 4 digit numbers in a column in Power Query, for example: 1234 3827 3845 4028 3957 The file is refreshed with a new list each week with a differing amount of numbers. I want PQ to combine them so they end up in a single cell in the following format...

Hello All, I want to convert column headers and then insert rows for usd, eur and other currencies, when transpose this data i will calculate x currency with f/x rate. I want to transpose with formula because i need to do this transpose each month. Thank you very much for your help in advance...

Smith, Bill 10-Aug Smith, Bill 17-Aug Smith, Bill 24-Aug Smith, Bill 30-Aug Jones, Nancy 9-Aug Jones, Nancy 11-Aug Jones, Nancy 15-Aug Jones, Nancy 21-Aug Jones, Nancy 25-Aug Jones, Nancy 31-Aug Doe, Jane 21-Aug Doe, John 10-Aug I have a list of names and dates that I...

Dear Excel and data experts, I would like to seek your help to create a formula/macro. I currently have a product spreadsheet in a table format which I need to convert into a list for uploading onto the sales systems. The problem is I am not sure where/how to start off and was wondering if...

Data is being pulled from SHEET1 and transposed and joined on SHEET2. Problem: Sheet1's column "E" is supposed to be at the top header row on SHEET2, but it is not working. Sub ReArrange() Dim a As Variant, b As Variant, cr As Variant Dim d As Object Dim i As Long, lr As Long...

Hi all, I have the formula =Cata!AE10-'Calc'!H5, and when I drag this across, I would like the rows in column AE to increment by 1 and the columns in the Calc sheet to increment by 1, therefore formula in the cell to the right should be =Cata!AE11-'Calc'!I5 and so on. I'm guessing that the...

Hello, I have a table with three columns. Date, Location, and Count. What I would like to do is keep the Date column as it is, make the Location column into three separate columns (Garage, Preferred, and Outdoor) and then populate the rows with the counts that correspond to the date by...

Hi all, I have multiple tables in the same workbook that are formatted with the column headers in one column and the corresponding data to the right (formatted this way for easier visibility of the user). See Tables 1 and 2 for examples. They all have the same naming convention beginning with...

Hello all, I have a sheet with several 'Boxes' of information side by side. Each 'Box' corresponds to a certain label. This particular sheet has 23 of these boxes I want to use power query or some other means to get those boxes stacked vertically instead of horizontally. Using Transpose in...

Hello Excel Community, I have a weird request which I am hoping someone might be able to provide a solution. I have rows where dates are provided in the following format yyyy-mm-dd and contain multiple dates in that format (Example: 2023-04-062023-04-072023-04-08). What I am trying to...

Hello, I have this excel where I have multiple questions and 4 options in a column as below; Question Option 1 Option 2 Option 3 Option 4 I am looking for the code which can convert these Options from rows to transpose to columns against each question. Please note there are...

I have a table extract and i'm using a combination of transpose and unique formula to bring in values onto Q2. I'm trying to filter this data so it only brings in column D, E, I L, and O. I keep trying to use the FILTER function but I get errors. I only need the yellow items in my example...

Hello Experts, I am working on a budget file where users are given an excel template to fill in Budget data for each line item as follows ( I have give We have another deptt who give us the erp based report where actuals which are booked under the planned head as follows we are doing this...