excel data

  1. I

    Power Query Data types and excel time format issue

    So, I have a column for time duration in my data from different excel files and tables which gets consolidated in power query... But the data in the time duration column from these different files/tables is not the same, it's in these below 3 example formats: 00:24:02 00h 24m 02s 24m 02s 01h...
  2. J

    Take Excel Worksheet, Divide into Worksheets/Workbooks by Employee/Card #, Email via Gmail to Employee for Input

    Apologies if this is completely basic, but I can't find anything in the forums that directly relates to what I'm trying to accomplish. I am not at all schooled in anything VBA, technical Excel, etc. I just Google to figure things out, and here I am! Here's my starting point: I have a workbook...
  3. A

    Adding data label and editing x-axis label

    Hi, I'm creating a tidal graph using a line graph and have two quick questions on data/axis labels... Question 1- How to add the time to the data labels, so it displays the height (column B) & time (column C) for each point stacked on a new line? It's currently automatically displaying only the...
  4. F

    Transfer Data from one sheet to another Sheet

    Hi Everyone, Hope you guys are well. In the attached pics I have two sheets - "Sheet1" and "Sheet2" in the same Excel file. I need to transfer the data on the "COUNT" Column from "Sheet1" to "Sheet2" Thanks in advance.
  5. J

    Suggestions for Exporting and Excel by Row into PDF Reports

    Hey everyone, I've got one that has kind of stumped me. I have about 50 rows of data 170 columns of data. I am trying to figure out a way that I can take that and create a PDF document for each row that has formatting set up by me. So basically the system to export 50 PDF's (one for each row)...
  6. S

    Transpose data to Horizantal

    This is related to Fantasy cricket. I'm trying to build an excel which will simplify preparing Grand League teams. Am facing issues in transposing data to horizantal. Source Data: ABCDEFGHIJKLMN2SNOTeam 1Team 2Team 3Team 4Team 5Team 6Team 7Team 8Team 9Team 10Team 1131 Dinesh Karthik...
  7. E

    Sorting or Arranging Columns with incorrect Row data

    I am very new to Excel so please excuse the limited knowledge of asking this question within this community. In Excel spreadsheet I have Twenty plus Columns, each with Headers, Example, Name, Email, Category, Phone, Address. Within each row down the column includes the marker and following...
  8. D

    Extracting data from Excel database to copy and paste

    I have data in Excel in 3 columns. Column A has Date Column B has Time Column C has Stock Price <o:p> </o:p> I am trying to copy the stock price for a certain time interval each day for different dates and paste them to column F. <o:p> </o:p> eg. I would like to copy stock...

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