transpose column to row

So I'm working with a horizontal table that tracks a count of calls per week per employee, currently formatted as Name 1/3-1/7 1/10-1/14 1/17-1/21 1/24-1/28 1/31-2/4 2/7-2/11 EMPLOYEE A 249 292 107 212 226 218 EMPLOYEE B 425 447 214 203 419 352 EMPLOYEE C 429 459 397 382 362 372...

Dear all, I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel: I have the current sheet of data: The formula and the data links to this test sheet of data: Now I have done about 90% of the work (I hope), seen as my...

Hello, Thank you in advance for assisting; much appreciated!! I have a spreadsheet with multiple columns of environment plus date field and trying to find a way to transpose each into row. Example: Project A has 28 columns, each column pertains to Env + if planned or actual + start or end...

Would like some help with a VBA script to transfer data as shown below. I tried to make it as simple as possible below. Sheet1: COL G-M may not always contain complete data. Therefore, only transfer the cells with actual data as a new row. See Sheet2 for how it is to look. The final result is...

Hi All, I am currently looking to use a VBA code for transposing data. I currently have a sheet set up which has 19 columns of data that i wish to keep in place and then and addition 7 columns which repeat across the sheet. It is these additional columns that i wish to transpose onto a new row...

I have a table with columns A-F and several thousand rows. I want to be able to easily transpose the the first rows (2-16) in column E as headings on a new page. From the F Column i alse need to transpose the data in row 2-16 to the new page. i need to do this for the entire F column. Every 15...

I have a large dataset with product related data in different columns for each data. <tbody> Date Product A Product A Product B Product B Qty Value Qty Value 01-09-2017 50 1000 40 800 02-09-2017 60 1200 20 400 </tbody> I want to make it columner base dataset...

Hi Guys, What is the case? I am trying to help a friend of mine, but I do not get there.... I tried R1C1 and transpose, but I don't get things how I want them. The starting point is as following: an excelsheet is retrieved from a database. The database allows only 1 format for exporting. On the...

I am trying to Transpose (Columns to Rows) with a set of rows are kept as columns. The image explains well. Alter the left column like the table on right hand side! <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> 1 1 6 11 16 2 2 7 12...

Hello all, I have been coming the archives of many forums trying to find a good, effective and safe solution for changing the layout of an SAP report exported to Excel 2010. It takes months and months to get them to provide us with information and while we have asked for raw data they seem...

Hello All, Below is my input table: <colgroup><col><col></colgroup><tbody> Compound Folder Name File name electrical documents a.pdf electrical documents b.dwg electrical documents c.pdf electrical documents d.xyz mechanical documents a1.pdf mechanical documents b1.dwg...

Hello, I am new to this forum and was looking to see if anyone can assist me please. I have a spreadsheet that has set of data which has 6 columns of data then a blank column and then again 6 columns and this spans across a lot of columns, every month a new set of 6 columns get added in. I...

Hello, I am really exhausted of trying to solve this problem. There is this spreadsheet It is a kind of questionnaire that is in different cells and I need to "transpose" cell to columns, but there are many data that must be deleted and others concatenated with spaces. Sometimes there are more...

Dear All, I have a column of data that contains addresses as a list. Some of these span 5 lines, some span 6, 7 etc. All are broken by a blank row however. <colgroup><col></colgroup><tbody> Company A Smith Road , The Square Smith Street London W1 7EQ Company B Unit 11...

Hi all, Thank you in advance for helping. I am very new for VBA and have some data would like to transpose from column to row where it is dynamic, see below, please - <colgroup><col style="width:58pt" span="2" width="77"> </colgroup><tbody> Item - Value 1 D 2 A...

Currently faced with the following issue, and can't figure out a solution so thought I'd ask the experts :) Data looks like this currently: <tbody> ID Serial Serial Serial Serial Serial Serial Serial Serial Serial 1234 <tbody> 12345678 </tbody> <tbody> 12345679 </tbody> <tbody>...

Hi First time post-er, excel newbie. I used Ron Bruin's VBA module to merge 732 workbooks into one worksheet. That worked great but each record (from each workbook) is spread over 38 rows. The data is all in the same columns (D, H, J and L), just spread out over 38 rows! What I need is a...

Need Macro for transposing address in column to rows. Here is the example data: Personal data removed per forum rules The data is not consistent, have few or no blanks at times.

I am using the code below which i got off this website in excel 2010. When I try running the macros gives me the "compile error: expected end sub". I am new to this. Please help. Sub Transfer() Function konkat(ByVal r As Range, Optional s As String = ",") For Each c In r konkat...

Hello, I need help on a transpose problem in Excel 2013. I have a set of data that has all it's information in one column and I would like take the cells and split them up into individual rows. Here is my data (the information has been changed because I don't want to add sensitive...