transposing

  1. P

    Transposing data in column B as rows for 59 csvs using VBA

    I have 59 csvs in the same folder that contain field names in column B. A1 contains just the filename. The csvs need to be set up in a certain way to facilitate data migration to a state database. I would like to transpose the data in column B as rows (for example, instead of field names in...
  2. C

    Transposing like all into the same column

    I have a table like <tbody> date organic referrer direct 01.01.2019 12345 123 23 25.01.2019 23456 234 34 03.03.2019 34567 345 56 15.04.2019 45678 456 78 </tbody> I want to get the...
  3. S

    Transposing values One after the other

    Hi Guys, I have data in multiple rows and i want to transpose the data into one column one after the other. i have to do it right now manually and it is very time consuming. Is there any way or formula to do it quicker. The format of data i have is: the way I would like to have it is: I...
  4. A

    Transposing - Line Break Cell

    <tbody> <tbody> 601, Khatau Condominium J.M. Mehta Road Nepean Sea Road Mumbai 400006 </tbody> <tbody> 601, Khatau Condominium </tbody> <tbody> J.M. Mehta Road </tbody> <tbody> Nepean Sea Road </tbody> <tbody> Mumbai 400006 </tbody> <tbody> Gold...
  5. J

    Transposing Data

    Hi, I am hoping someone can help me out transposing some data. Ive got a raw excel file with all the data in column A. Every 21 lines this is suppose to be posted across the same row. I've tried manually selecting every 21 lines and repasting this with the transpose option. Problem is that...
  6. C

    VBA to transpose rows to columns with varying rows (and remove first character)

    Hi I have an Excel file (exported from a system) which has rows of data. I need the rows transposing to columns. The problem I have is that the set of rows varies so it's not as simple as rows 1-5, then 6-10, 11-15, etc to transposing columns. An example of my data is below: COLUMN A...
  7. F

    Transposing and calculating formula

    Help? I have created a mileage chart for site to site distances. The sites are listed horizontally and vertically. The bottom half is the distances between sites, the top half is for the cost. It's this that I am trying to calculate. B2 = distance 1 = 100 B3 = distance 2 = 150 B4 = distance 3...
  8. D

    Transpose from cell to multiple rows

    Hi all, Im looking for a way using VBA code to transpose data contained in one cell separated by ";" to multiple rows. Below is an example of what im trying to achieve Event ID Day Start End Room 1 Monday 09:00 11:00 Room 1; Room 2; Room 3; Room 4 1 Monday 09:00 11:00 Room 1; Room...
  9. F

    Formatting LAS files (blocks of data that should be across one row)

    I am trying to format a large amount of data that comes up like this... 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 .... I would like to have the bold numbers going down a single column. The remaining numbers i would like to...
  10. M

    Changing Multiple Rows into One

    I'm using Excel 2013/Windows 7 and I think I'm looking for a macro here but you tell me... I have a large list of employee changes (hires and terminations) from the past two years where almost all employees are listed more than once. For example, if someone was a new hire, then terminated, then...
  11. I

    Massive Transpose

    Hi All! I have a library of information in an excel sheet that I want to be able to format in a certain way. Currently the way that it is set up is like this: (here's a snippet)...
  12. A

    Match cells in column, then transpose matching row data from column b, c etc on many

    I have a spreadsheet with multiple tabs, and would like to transpose the data on each tab in the way described below: So if I have: 1 a 1 b 1 c 2 a 2 c 2 d I would like to get 1 a b c 2 a c d Same with multicolumn. if I have 1 a b c 1 d 2 e f g h 2 i j Would like to get 1 a b c d 2 e f g...
  13. P

    Help moving data from rows to columns

    Hi Really stuck with this one - wondering if anyone can help I've got a data sheet that looks a little something like this: 1 2 3 4 5........31 Mary Q1. a e i m q...... Q2. b f j n r...
  14. A

    Transposing to Dimensionalize/Tabulate Data

    Below is showing the data I have (Data Format Original) and then the format I want the data to be in (Data Format Final). If you are having any issues seeing this picture just let me know. I have attempted to go through this process via PivotTable however I was restricted since I was unable to...
  15. A

    Pivot Table Row Labels

    Data: Hourly Pricing 1-24 since April 2009 *Sample Shown Below*) Current Pivot Table The pivot table's Row Labels go by "Year"-> "Month"-> "Day" and I want it to go "Year"-> "Month"-> "Day"-> "Hour" Below is a link to another thread where I was trying to achieve the above goal by...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top