transpose columns

Hi, I have a situation where in I have data where the hierarchy goes as follows Region>Country>Plant>crusher Name>Machine Score>Machine score check date. is there a way to transpose the score 1 date below the most recent score column and the date next to it using formulas and likewise for other...

Hi there, I have a sheet in the following format <tbody> Date Key1 Attr1 Key2 Attr2 Key3 Attr3 Key4 Attr4 1 Jan 2019 1 23 3 43 3 25 1 54 2 Jan 2019 2 23 2 23 2 54 2 23 3 Jan 2019 4 25 1 54 4 43 2 34 4 Jan 2019 3 23 4 23 2 32 4 23 5 Jan 2019 1 27 1 24 1 14 2 44 </tbody> which I want...

i had created an excel 2016 sheet that took 4 columns of data (week, meal time, meal name, food item) and transposed and grouped that data using power query to create a list of food items, by week (columns) and grouped by meal time/name as rows. unfortunately, this was developed for a mac...

Hi Can any one help me on this transpose the available following data in a particular format. This data will continue for more than 650 rows & 26 columns <colgroup><col><col><col span="7"></colgroup><tbody> Emp. No. Name Comp1 Comp2 Comp3 Comp4 Comp5 Comp8 Comp9 2002 A 2000 800 1600 2500...

Hello, Thank You all for Your huge help solving lot of issues and helping out. My first example with this issue was in the post here. I got two response for fixing this issue. I thought about how to change code into 1st of the answers (given by Rick) to make it work for situation stated...

Hello Excel Community. Once again I got a problem. This one is similar previous one, but at the same time different. <tbody> Original: <tbody> A B C D E F G H I J K L M 1 Name Color 8 10 12 14 16 18 20 22 Price 2 T-Shirt White N $10 3 T-Shirt Black...

Hello! I have been working on this issue all day, so I am hoping someone here is able to help. I am trying to create a VBA script that will allow me to easily complete a copy > paste special (transpose) operation. 1. I need to select a custom range of data 2. Loop through the data by row 2.1...

Hi All, I'm trying to import data from Excel into ArcMap and I'm running across some issues with a database. Basically I need each building (row) to contain links to all drawing data. Different buildings may have different numbers of drawings. Basically I want to convert something that looks...

Hi I have answers to a survey from about 140 people listed in one column. The survey is 52 questions long. I need to transpose the data, so the first 52 rows in the column are transposed into one row 52 columns long, and then the next 52 rows are transposed into the row below the first...

Hi! I have a spreadsheet full of data. The first three tabs are considered summary data and the 4th is where the data is pasted from. Data output comes from a SQL query (already made). The output comes out vertically and every cell is linked to the 4th "Data Paste" tab. Yet, I have a request to...

Having read what seems like hundreds of forum posts about using a macro to transpose data from columns into rows, I still haven't managed to get my macro to work. I need to go from this: <tbody> 1 2 3 4 Category A Record 1 B C D E Category A Record 2 C D E Category B Record 3 C A...

:confused: Good morning friends. I am hoping that one of you can help me. I have an excel spreadsheet that is just two columns (A and B) I would like to have them transposed into a text Document when I click a button (already made and I can assign macro) All I need is a code to do it. So far...

Hi VBA experts I have a table with an identifier in column A and values in columns B to Z. The structure is like this: <tbody> IdentifierA value1 value2 value3 value4 IdentifierB value5 value6 IdentifierC value7 value8 value9 value10 value11 value12 IdentifierD...