transposing

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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